Carrying over combobox values--
Say I want The Value of ComboBox1 on Sheet 1 to carry over so that the value of ComboBox1 on Sheet 1 is exactly the same.
What is the code for that? I'm sure this is incredibly easy but I cannot figure it out.
-thanks
Bookmarks