Greetings everyone. i have a problem i was hoping someone could help me with. i have a userform which has a listbox and a "Add" command button. the problem i am having is that when the listbox is selected and then the user hits the "Add" command button, this action causes the duplication of the highlighted information into Sheet1.
Is there a way that when the listbox is selected that the "Add" command button is grayed out and disabled to prevent the user from using that button?
I would appreciate any help that you can give me!
david
Bookmarks