Userform List Box content not visible?

  • Thread starter TotallyConfused
  • 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.
 
R

Rick Rothstein

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

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
 
T

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.
 
R

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
 
T

TotallyConfused

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

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top