I dont know if this makes sense, or if it is possible...
I would like to create the following...
1. User opens workbook
2. Message Box appears asking user to select a customer name from a drop down list.
3. user picked customer name gets put into a specific cell
Where is the data that popluates the drop down list located? A simple UserForm would accomplish this.
Hello Legend Rubber,
You can this by creating a UserForm with a ListBox.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
The data that populates the drop down list would be on a page inside the workbook that is opening... I dont know anything about UserForms... can someone help me with that?
Hello Legend Rubber,
You would need to post a copy of the workbook.
Maybe:
Assumes D1 has the dropdown list and A1 is the specific cell.
Please Login or Register to view this content.
Please Login or Register to view this content.
OK, i have learned the basics of the UserForm and have got that working... question...
I have the following code...
I want to skip this if a CheckBox is filled... how would i do that?Please Login or Register to view this content.
Hello Legend Rubber,
Assuming your check box is named "CheckBox1"....
Please Login or Register to view this content.
i have a block if without end if error....
where does the end if come after checking the checkbox?
Hello Legend Rubber,
If you copied the code as posted, there should be no error with the change. "IF" statements can be either block style or single line. The added statement is a single line "IF". The remaining lines are block style.
ok, i got that to work to exit the sub without doing anything... what if i wanted to do something if the checkbox was checked? so..
if the checkbox is checked i would want the following...
Else i would like the original to take place...Please Login or Register to view this content.
(Also, the above code is the same thing for 3 separate worksheets... is there an easier way to do this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks