Hi Folks,
I have searched the forum but cannot find anything that does what i want, or anything that i could amend to suit.
I am looking for help with a code that will do the following.
Find the first empty cell in "sheet1" range ("B5:B16") and then place the text of ComboBox1 in the empty cell and the text of ComboBox2 in the opposite cell in column "C".
Example:
If B10 was the first empty cell in the range then:
B10 would = ComboBox1 text
C10 would = ComboBox2 text
If all cells full in the range B5:B16 then a msgbox appears.
I would appreciate any help at all with this.
Thanks
Charllie
I have searched the forum but cannot find anything that does what i want, or anything that i could amend to suit.
I am looking for help with a code that will do the following.
Find the first empty cell in "sheet1" range ("B5:B16") and then place the text of ComboBox1 in the empty cell and the text of ComboBox2 in the opposite cell in column "C".
Example:
If B10 was the first empty cell in the range then:
B10 would = ComboBox1 text
C10 would = ComboBox2 text
If all cells full in the range B5:B16 then a msgbox appears.
I would appreciate any help at all with this.
Thanks
Charllie