sheet2.Range("A1") = Me.cbo1.value
If cbo1 is populated by its .ListFillRange property and that list-range includes cell Sheet2.Range("A1") , then writing to a cell in its list-range will trigger cbo1 to re-populate and in turn trigger it's _Click event.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks