VBA previous records are being ammened to what is current is

[Logistix]

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

 

[Smitty]

Care to post your code?

Smitty

 

[Logistix]

Just managed to figure it out. Thanks Smitty