user prompt

  1. L

    VBA Save As with User prompted to select folder path

    I have a macro that uses the GetSaveAsFilename which is fine except it makes the user type in the file name to save the file. The issue is people mistype the file name which messes up other macros down the line. The file name never changes but the folder location does so the user needs to be...
    • lwebbie
    • Thread
    • file file save as folder path user prompt vba & macros
    • Replies: 6
    • Forum: Excel Questions
  2. R

    Prompt User for Range Input and then Use in Formula

    I was trying to create a way to replace state abbreviations with full names. I found a great formula for this (below). What I would like is to replace the hard coded range with a prompt to the user for the range ("Select the List State Abbreviations"). I would also like the VBA script to ask the...
    • rex_411
    • Thread
    • range used in formula state abbreviation user prompt
    • Replies: 3
    • Forum: Excel Questions
  3. Gingertrees

    How to prompt user to define a named range

    I know how to import a sheet into a workbook, but what I don't know is how to prompt the user to define a named range based on said sheet. (I tried to explain this earlier, but muddied it up with too many details.) Each day, I copy a sheet into my workbook, that has a useful range that always...

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
Back
Top