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.
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
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).
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.