I have in cell A2 a dropdown list using data validation so that a user can enter value from the populated list. The values are in Cell range C2:C6 which appears as dropdown list in cell A2. I am looking for a solution to set a default value as "-selsct from list-" when the work book is open always for entering datas.
Put this in the "ThisWorkBook" module and save the file. When you reopen the values will be there in C2 to C6
Amend the sheet name to match yours
Please Login or Register to view this content.
If a response has helped then please consider rating it by clicking on *Add Reputation below the post
When your issue has been resolved don't forget to mark the thread SOLVED (click Thread Tools at top of thread)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks