Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing worksheet as a variable
Hello, this is my first post on the website, and I am a newbie at this.
I am trying to do a couple things I guess. First of all, in a macro, am trying to get a hyperlink to reference a worksheet in the sam workbook. The catch is, I have a userform where you have two tex boxes where you input someones first name and someone's last name. Th last name is stored in a variable. I want to use that variable t reference the new worksheet that is created with that last name as th worksheet name. Sub OK_Click() Dim f As String Dim c As String f = First.Text 'reference to my textbox c = Last.Text |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable cell referencing | Excel Worksheet Functions | |||
Referencing tab based on Variable | Excel Worksheet Functions | |||
Variable Cell Referencing | Excel Worksheet Functions | |||
Referencing Variable Name Worksheets | New Users to Excel | |||
Referencing variable | Excel Programming |