Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command button help
I have some command buttons on a userform. I want each of these command
buttons to take me to a different worksheet in the workbook. I am so new to VBA and don't really understand it at all. I have the command button on the form, I double click it to bring up the code window and it automatically puts in Private Sub EmployeeBenefits Click_() End Sub (EmployeeBenefits is the name of my command button) I have five of them with different names) I added the following to try to get it to go to the sheet... Sheets("Employee Benefits").Select It says it is out of range. Can someone help? I am clueless. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command button help
Double check the worksheet name as invalid name will give out of range error.
"Anna B" wrote: I have some command buttons on a userform. I want each of these command buttons to take me to a different worksheet in the workbook. I am so new to VBA and don't really understand it at all. I have the command button on the form, I double click it to bring up the code window and it automatically puts in Private Sub EmployeeBenefits Click_() End Sub (EmployeeBenefits is the name of my command button) I have five of them with different names) I added the following to try to get it to go to the sheet... Sheets("Employee Benefits").Select It says it is out of range. Can someone help? I am clueless. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command button help
Ok great, that worked, except, now, my userform stays in the front, and
behind it is my employee benefits worksheet. I guess I need to do something else to show it? Could I use show instead of select? Thanks. "Toppers" wrote: Double check the worksheet name as invalid name will give out of range error. "Anna B" wrote: I have some command buttons on a userform. I want each of these command buttons to take me to a different worksheet in the workbook. I am so new to VBA and don't really understand it at all. I have the command button on the form, I double click it to bring up the code window and it automatically puts in Private Sub EmployeeBenefits Click_() End Sub (EmployeeBenefits is the name of my command button) I have five of them with different names) I added the following to try to get it to go to the sheet... Sheets("Employee Benefits").Select It says it is out of range. Can someone help? I am clueless. Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command button help
Hi Anna B,
You need to dismiss the userform. You can click the close button in the corner ( X ), or add this line after Sheets("SheetNameHere").Select: Unload Me That will close the form so you can continue working on the selected sheet. Regards, GS |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command button help
Do you use
userform1.Show vbModeless in xl2000 or later If so, the user will be able to select and work with the worksheet, but the userform will still stay in the forefront. If your just trying to work with the ranges on the worksheet, there is no reason to select anything. Since you haven't said what you are actually trying to achieve, why not talk about that. -- Regards, Tom Ogilvy "Anna B" wrote in message ... Ok great, that worked, except, now, my userform stays in the front, and behind it is my employee benefits worksheet. I guess I need to do something else to show it? Could I use show instead of select? Thanks. "Toppers" wrote: Double check the worksheet name as invalid name will give out of range error. "Anna B" wrote: I have some command buttons on a userform. I want each of these command buttons to take me to a different worksheet in the workbook. I am so new to VBA and don't really understand it at all. I have the command button on the form, I double click it to bring up the code window and it automatically puts in Private Sub EmployeeBenefits Click_() End Sub (EmployeeBenefits is the name of my command button) I have five of them with different names) I added the following to try to get it to go to the sheet... Sheets("Employee Benefits").Select It says it is out of range. Can someone help? I am clueless. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command button add another command | Excel Discussion (Misc queries) | |||
Command Button vs Form Button | Excel Programming | |||
Command Button | Excel Programming | |||
Command Button vs Control Button | Excel Programming | |||
Command Button vs Form Button | Excel Programming |