PDA

View Full Version : Userform from hidden worksheet



lhtqasonline
02-22-2010, 04:49 AM
Hi I have a userform but I want the data sheet to be hidden
It is a pricelist and I want users to only be able to lookup a single item price

How can I specify the row source in the userform if the data is on a hidden worksheet?

Bob Phillips
02-22-2010, 05:43 AM
Don't! Load the form explicitly from the data.

SamT
02-22-2010, 06:08 AM
Good morning, XLD.

One of us hasn't had enough coffee yet, 'cuz I don't understand what you mean.

SamT

lhtqasonline
02-22-2010, 07:09 AM
Yes sorry I don't know what you mean or know how to do that

Bob Phillips
02-22-2010, 08:26 AM
What I mean, and I have had my coffee, well tea as it is afternoon here, is that rather than bind your userform controls to a worksheet range using RowSource, just load the control directly, for instance


TextBox1.Text = Worksheets("Sheet1").Range("A2").Text

SamT
02-22-2010, 08:53 AM
Ah!

Thanks.

Sorry 'bout the coffee quip. I know you probably drank tea, and although I also know that you see the sun long before I do, that information did not percolate thru my sleep clogged mind, 'cuz I didn't have coffee.

Bob Phillips
02-22-2010, 09:16 AM
No problem, I was just trying to continue the light-heartedness :)

BTW I drink coffe and tea (when I'm not drinking beer that is).