Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keeping a userform visible | Excel Programming | |||
UserForm unloaded still visible | Excel Programming | |||
UserForm unloaded still visible | Excel Programming | |||
Userform always visible | Excel Programming | |||
How can I make the bar that shows the content of the cell visible. | Excel Discussion (Misc queries) |