MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Userform Raw source

Posted by Paul Magruder on March 14, 2001 8:40 AM

I am having trouble keeping the "raw source" used for a listbox in a userform. I have 2 sheets, sheet1 & sheet2. The data used as the rawsource for the listbox is in sheet2, range b4:b6. In the properties window, I have the raw source set for B2:B6. It Works fine until I open the workbook the next time. Then it seems like its looking at sheet1 B2:B6. How do I make sure it is getting the data from the correct sheet?

Thanks in advance
Paul Magruder

Posted by Dave Hawley on March 14, 2001 9:12 AM

Hi Paul
The best way is to simply name your range.


OzGrid Business Applications