Userform List Box content not visible?

[TotallyConfused]

Hi I have a Userform with listboxes they were working fine. However, going
back forth and making changes etc. two of my listboxes are not visible. The
properties are set to "True" for Visible. I tried entering the Control
Source and Row Source but it gives me a error message, "Could not set the
Control Source/Row Source property. Invalid property value." Can someone
please help me with this not sure what I did wrong. Thank you in advance for
any help you can provide.

 

[Rick Rothstein]

**Exactly** what did you try entering for the Control Source and Row Source?

 

[Patrick Molloy]

if rowsource is like this
A6:A16
then it will pick up from whatever is the active sheet - so nothing gets
loaded

instead use
sheet1!A6:A16

 

[TotallyConfused]

Thank you for responding. I have in the Row Source A1:A150. It will not let
me add anything else like you suggested Sheet1A1:A150. If I try entering
"Sheet1", it will give the same error message. Could not set the Row Source
property. Invalid property value." However, I have the list option set to
1. Only the checkboxes are visible there is no text. Is there any thing
else that can be wrong? thank you.

 

[Rick Rothstein]

I have in the Row Source A1:A150. It will not let

me add anything else like you suggested Sheet1A1:A150.

You missed the exclamation mark (bang symbol) between the sheet name and the
range address...

Sheet1!A1:A10

 

[TotallyConfused]

I did include it in my property. I am sorry I did not type it in my reply.
Any other suggestions?

 

[TotallyConfused]

I figured it out!! I was putting in the Row Source Sheet1!A1:A150. It did
not accept this. I had to put the sheet name like "Specialties!A1:a150"!!!

Thank you both for help and patience. Have a great day!