Been a while since I haunted you, hope all is well with you and yours!
My question is this:
Is there a code that will select a sheet based on the value of a worksheet cell or even better, a label caption? The cell or label number value is a known valid sheet number.
If I have a label in a Userform that is named "ReportNo" and the value in that label is "11-11-SR". I have a valid Worksheet named 11-11-SR. I need a code that will make that sheet the Activesheet based on the value of ReportNo.
Kinda like this? Worksheets("Me.ReportNo").Select
Thanks very much in advance!