dialog box vba

  1. B

    Add an 'ask' function to 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...
  2. T

    Choose Selection from User Dialog

    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...
  3. S

    Open File Dialog - Specified path

    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...
  4. A

    Enter Text in Name box in VB Code help needed

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

    Recalling a multiple sheet selection in VBA

    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) ...
  6. T

    Excel VBA Code to combine multiple Excel files

    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...
  7. H

    Open Colour Select Dialog Box

    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...
  8. J

    VBA help - multiple sheet in dialog box to create pdf

    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...
  9. D

    Pivot-Table DATE-FILTER Dialog Box

    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!
  10. B

    chosing filename in dialogbox + press ok with using vba...

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top