Drop down changes

  • Thread starter Thread starter gavmer
  • Start date Start date
G

gavmer

Hi all,

Im using multiple combo boxes but have a problem. When i save th
document and re-open, the data in the linked cell is correct but th
window in the combobox states a different item. I would like this t
remain the same so when a user goes in, they can see what has bee
selected.

Any ideas?
 
Use Auto_open in a module.

sub Auto_Open()
activecell.offset(0,0).select
frmMain.Combo1.text=activecell.offset(0,0).value
Load frmMain
frmMain.show
end sub
 
Hi Mark,

Thank you. I am still having trouble unfortunately. Couold you possibl
have a look at my workbook???

Cheers!!!
 
Back
Top