I have a dropdown with vlookup in a sheet, I used Bill's clear and save , works great. Heres my situation, I want to have the cells with the dropdown go to the top of the list "Select" when I run his macro. Cant find this anywhere. That way when the workbook is open the areas that need to be filled in are blank (where data is entered) and the dropdowns default to "Select" Any help.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
cooper645
Well-known Member
- Joined
- Nov 16, 2013
- Messages
- 639
- Office Version
- 365
- Platform
- Windows
- MacOS
- Mobile
- Web
How are your drop downs populated? From a list on a data sheet or directly in data validation source?
Either way way you would need Select at the start of the list and on the ‘Workbook_Open code those cells to default to select. That should do the job,
Either way way you would need Select at the start of the list and on the ‘Workbook_Open code those cells to default to select. That should do the job,
Upvote
0
Similar threads
