Unable to add data to List and Comboboxes

[mdmackillop]

Can anyone give some insight here. Joanna has created a simple userfom base on my sample, but she gets a permission denied on the following lines



ComboBox1.List = Range("unique").Value
ListBox1.List = Range("all").Value


I get the same result with her form, but If I add new controls and amend the coding accordingly, the Userform opens.

http://www.vbaexpress.com/forum/showthread.php?t=2524

[Jacob Hilderbrand]

Is the RowSource Property set for those? If so get rid of that range and you should be able to change the data fine.

[mvidas]

Malcolm,
Same thing as Jake said. When I removed the 'unique' .rowsource for her Combobox and the .text entry she had, and 'all' .rowsource for her Listbox, it worked fine for me.

BTW- nice image, you take that from your backyard? :)
Matt

[mdmackillop]

Thanks both. A fresh 2 pairs of eyes helps!

Matt, The view is from our local "hill park", about a mile from where I'm sitting.

[mvidas]

Thats just beautiful. Heres about a quarter mile from me:
http://www.10nbc.com/gfx/weather/metro_pic.jpg
In fact you can see my building in that link. On the right side, the brick building between the white/black striped parking garage, and the tall grey building behind it.

http://www.10nbc.com/gfx/weather/brighton_pic.jpg
In this one, again on the right side, the one directly in front of the white dome-capped building (where JOrzech works!)

Both taken from http://www.10nbc.com/skycams.asp?metro=Y

Matt

[mdmackillop]

Weather looks nice!

[mvidas]

In your local hill park the weather looks great, you must have hit the webcam at a rare and lucky instance where the sun was shining :)

[mdmackillop]

Not a web cam. I can only find one here, a lovely picture of the runway at our local airport to show the weather!