Userform List Box content not visible?
 

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.

Userform List Box content not visible?
 

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

--
Rick (MVP - Excel)


"TotallyConfused" wrote in
message ...
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.

Userform List Box content not visible?
 

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" wrote:

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.

Userform List Box content not visible?
 

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.

"Patrick Molloy" wrote:

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" wrote:

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.

Userform List Box content not visible?
 

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

--
Rick (MVP - Excel)

Userform List Box content not visible?
 

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

"Rick Rothstein" wrote:

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

--
Rick (MVP - Excel)

Userform List Box content not visible?
 

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!

"TotallyConfused" wrote:

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

"Rick Rothstein" wrote:

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

--
Rick (MVP - Excel)