Hi there,
I am entering data into a userform using comboxes that stores itself onto a new line in excel. The only problem is when I goto enter a new record the previous row/s in excel is ammended to what I have last entered.
Is there a way to refresh the value contained in my combobox, without ammending the 'last entered" record.
Kind of like a "paste special" as "values" thing??
Thanks, Steve
I am entering data into a userform using comboxes that stores itself onto a new line in excel. The only problem is when I goto enter a new record the previous row/s in excel is ammended to what I have last entered.
Is there a way to refresh the value contained in my combobox, without ammending the 'last entered" record.
Kind of like a "paste special" as "values" thing??
Thanks, Steve