Attached is a test filling of a list box.
You need to open the form via the immediates window : Tools>Macro>VB Editor - Ctrl+G - ufrm(ctrl+space).open vbmodeless
Then flick back to excel sheet.
There should be a form there, click on refresh and it should pull the cells data into the list box.
Grab what you need from it. This is only one way to do this
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
Reply With Quote