Combo Box Listfillrange

  • Thread starter Thread starter stewart
  • Start date Start date
S

stewart

I've just reloaded a document and the listfillrange of a
combo box embedded on a worksheet will not accept any
values. Previously a macro assigned a listfillrange to the
combo box based on certain parameters, but that doesn't
work now that the combobox just blanks out any attempt to
add a list fill range.

Help!!!

Stewart
 
Are you doing it manually

in the listfillrange property put in

Sheet1!A1:A10 for example

If in code

Activesheet.combobox1.ListFillRange = "Sheet1!A1:A10"
 
I've done it manually and by macro AND I've tried typing
in nonsense values, no matter what I do text I put in the
box just vanishes as if I had typed in nothing...

Stewart
 
Back
Top