dialogbox

  1. U

    Can I use Excel VBA Dialog box to display files starting Day*.xml so that my user can choose file to open

    In Excel, the following VBA code does not work properly. dlgAnswer = Application.Dialogs(xlDialogOpen).Show("day*.xls") It opens the Dialog Box but shows all files in the folder (including day*.xls). I was expecting it to show only the files starting with filename as day* . I tried Fileopen...
  2. D

    Unable to load .data file in excel using VBA

    Hello, I'm trying to build a dialog box where will ask me to load a .data file extension file which later on i will edit few things and save as .xlsx. Problem is that whenever the file is selected and supposed to be loaded, there is no outcome... it simply ends macro as if nothing happened...
  3. R

    Set Lrow by dialog box? & Loop batch size limit

    I am compiling a register of projects and have been using VBA to Loop through 25-40 files in a batch. As the list gets longer I have been manually changing this in the macro text. 1) Does anyone know if i can use a dialog box to set the Lrow, to add to bottom of list? (So I can't forget to...
  4. Trevor3007

    msg/input box

    hi. On the worksheet named 'timesheet' I want to put a msgbox to state "input date In Cell A2" and a input box to appear & place the applicable in a2. Then move to the worksheet called 'Sheet1' . Again I need a msg box to say"Attach File" and move the cursor H2 and upon enter run the...
  5. Trevor3007

    add multiple files (various file types)

    hi, I the following code:- Sub GetFilePath() Dim dialogBox As FileDialog Set dialogBox = Application.FileDialog(msoFileDialogOpen) 'Set the display properties - these are optional 'All the settings must be applied before the .Show command 'Do not allow multiple files to be selected...

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