notes

Hi there, I would like 3x input boxes to popup asking the user for information. When I just add the code for the first one, it works fine. However, I get errors when I add the next two codes. How do I amend the code so that each box pops up one after the other? Thank you! Sub ssFav() Dim...

So MS has renamed the old Comments to Notes, and the new Comments have become threaded conversations. We're now using Notes in the same manner as we used to use Comments. The problem is, EDIT NOTE nor NEW NOTE appear in the right-click menu when in a cell that has a Note, only DELETE NOTE. Is...

To set the scene: I have 800 or so products, each with a unique identifier. These products have associated notes on a system, each with a varying number of notes. These notes are managed on an Excel document. Therefore, on a spreadsheet, I have groups of products. Some are in groups of 2, some...

Hello Everyone, Ive built a Spreadsheet which will reveal some rows (which contain notes) once a button is pressed. It will then hide the rows once another row is pressed. Below is a simplified version of the sheet. So once we press the 'Show Notes' button above it will run the simple macro...

Hello Everyone, I would like to compare data from multiple workbooks but I am finding it quite cumbersome to reference all the sheets in formulas. I'm also finding it cumbersome because I can't seem to make the workbook references relative either (i.e. C:\mydir\workbooks\file.xls vs \file.xls)...

Hi, I would like to open the userform & see in TextBox5 NO NOTES FOR THIS CUSTOMER without me having to type it. I have tried like below but i get an error message, run time error 424 object required Private Sub Image1_Click()DatabaseInput.Show TextBox5.Value = "NO NOTES FOR THIS CUSTOMER" End...

Hi Everyone, I add my sales into sheet "Quotes" Range is D27:O51 The data for each sale is two rows, row1 the details, row2 Notes, (Not all sales have notes) so what I want is a macro that will copy the last "Row1" sales details and paste it below but it needs to place it 2 rows down to miss...

hello- I've been trying to write a piece of code to save-as a workbook. Here are the criteria- and I can fill in the "xxx's" if someone lays them out for me. Help is much appreciated. Needs to save-as on a C:\Users\Bridge\Desktop\Noons\Noons-Arrivals\(Myfile) The name needs to come from...

I wasn't sure I wanted to convert my old comments/new notes to new "threaded comments" when I first started using the latter so didn't agree to convert when asked by Excel, but now I cannot find a global convert option. Is there one?

Dear All, I am not sure it this can be done. I have some info one one tab from two spreadsheets; in one lists (columns A:G) there is some information, but no NHS number, in the other list (column H:I) there is the NHS number and some info. Is there a way to combine the information so that...

<tbody> Account number Account notes 123 Account status updates pending review, docs due by EOW </tbody> Working with alarge Excel document with several worksheets (a new worksheet is generated eachday - each named as the date). Today's worksheet is 9.2.18 and yesterday's worksheet is...

Good morning, I'm hoping someone may be able to help. I have a list of invoices with amounts and applicable notes. Even though invoices and amounts are the same, there are multiple rows for each invoice because the notes are different. As a result, using the example below, when I pivot the...

Good morning. First of all, I'd like to mention I have also posted this issue here: https://chandoo.org/forum/threads/copied-table-missing-first-column.39243/ http://www.vbaexpress.com/forum/showthread.php?63260-Copied-Table-Missing-First-Column I've got an issue I can't seem to wrap my head...

Good morning, I hope you're all well. This might be a tricky one and hoping someone can help. I'd first like to point out that my VBA knowledge basic and the majority of the code I've used came from the final post at the following link...

I am using a macro from Ron De Bruins website to send selection by email from excel. It works quite well but it does so in the background. It would be helpful if I could first see the email so I can add personalized notes to it before sending it. But I do not know how to modify the macro. If...

Hi guys, I'm trying to create a formula to look into a box and sum up how many of x application are within a certain column. So for example i have the below <tbody> Username Notes Resolution User1 This is the notes field where application thisisapplication1 is held as proof for blah YES...

HI i really hope you can help me with the below query in VBA code in excel, i have the following issue with duplicates on a spreadsheet and mssing data on duplicate lines but i want this merged all into one line if possible. -Sheet name = Sheet1 -Data range (column(s), rows) = A - Z -Data-type...

I have a large Excel document with worksheets for each new day. Yesterdays file updates were added in the Notes column (DZ) of that days worksheet (5.14). Today's worksheet is 5.15 and again the notes column is DZ. I'm looking for a formula that will copy the text from yesterday's notes (the...

I would like to set up a Standard Notes wizard for our drafters. For my example, we make three different types of drawings: Assembly, Welding, and Sheet Metal. I would set up a table with notes in the rows and drawing types in the headers. <tbody> NOTE ASSY WELD SHTMTL INTERPRET DRAWING PER...

Hello everyone, I have this excel spreadsheet and one of the column contains notes. I want to be able to extract a specific text based on a common user. Below is an example of what is on the notes column. These are all on one cell. Test,Name1 10/18/2017 8:43:15 AM > FAXED Test,Name2...