dialog box vba

I have a macro that loops through sheet2 column A and if found on sheet1 column A copies to next row on sheet3. The code works well, but I am coming across new sheets, where the code will need to search sheet1 in different columns, ie g,c,h etc. I can just edit the code each time but others are...

Hello, I need to make a dialog after I open a sheet so the user is only looking at the info that pertains to them. There is a column that categorizes the row into 1 of 14 categories. I want to delete every row that does not pertain to the user some users have multiple categories and some just...

I have a MAIN workbook and i also recieve daily data (in Excel format) that needs to be added to this Main workbook. This daily file is saved in a specific network folder. I'm looking for VBA to open the "Workbook Open" dialog box on a specified network path by default and to allow the user to...

I need too make a code too make the following dialog box.. could someone PLEASE give me the code? Excel Help Forum

Hi, I have a macro that will select multiple sheets at one point. I'm trying to think of a way to recall that selection later on, possibly by naming it when it's first selected. I thought something like this would work, but no dice: SheetstoPrint = Sheets(ActiveWindow.SelectedSheets) ...

The following code opens a dialog box for the user to select files. I want it to determine which files to consolidate (using the loop). 'The following code will combine all data into one excel workbook. Sub CombineFiles_Step1() 'Declare Variables Dim WorkbookDestination As Workbook Dim...

Hi, People I am making a macro which uses useforms to guide users through a selection process; one step requires the user to be able to define a colour. To make this friendly and pleasant, I would like to invoke the colour selection dialog box that can be seen by clicking on the fill colour...

Hi. I have a workbook with multiple sheets. I would like some help with the VBA that can help me do the following: Select only certain sheets from the workbook Create a dialog box so that a user can pick a more limited number of these selected sheets Combine selected sheets, collated into a...

Hello, I have a PT named "TAL". I want to pop-up the DATE-FILTER Dialog Box by vba code. This code: Application.Dialogs (xlDialogPivotFilters).Show Dose'nt work! Is there a way to do this?... TNX!

i do face an excel which several sheets, all refering to other files but looking exactly the same. i finished now one country, i still need to do so for all the others. so what i need to do is simply now replace all "CAN"-characters with "US", now i have all references to other files changed...