Userform List Box content not visible?

  • Thread starter Thread starter TotallyConfused
  • Start date Start date
T

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.
 
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
 
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.
 
I have in the Row Source A1:A150. It will not let
me add anything else like you suggested Sheet1A1:A150.
Click to expand...

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

Sheet1!A1:A10
 
I did include it in my property. I am sorry I did not type it in my reply.
Any other suggestions?
 
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!
 
Back
Top