Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button vs Command Button
I have a workbook where I used a button and assigned the following macro:
Private Sub T12_Click() Sheets("T1-05").Select Range("A17").Select End Sub In revamping the sheet I used a command button and loaded the code in to it. Works fine in the button, in the Command button I get a Run-time 1004 Select method of Range class failed. Why is this happen. A17 had data in it though it is linked from another sheet in the same workbook Secondly if you have a sheet that uses many buttons mostly for navigation which would be the better route the macro with the button or the coded command. Trying to keep file size down. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button vs Command Button
Private Sub T12_Click()
Sheets("T1-05")select Sheets("T1-05").Range("A17").Select ' or ' Sheets("T1-05")select ' Activesheet.Range("A17").Select ' or ' with Sheets("T1-05") ' .select ' .range("A17").select ' End With End Sub Unqualified ranges in the worksheet module are the equivalent of me.Range("A17").Select since me (the sheet containing the code) is not the activesheet, you can't select Range("A17") on that sheet and you get an error -- Regards, Tom Ogilvy "Dan" wrote in message ... I have a workbook where I used a button and assigned the following macro: Private Sub T12_Click() Sheets("T1-05").Select Range("A17").Select End Sub In revamping the sheet I used a command button and loaded the code in to it. Works fine in the button, in the Command button I get a Run-time 1004 Select method of Range class failed. Why is this happen. A17 had data in it though it is linked from another sheet in the same workbook Secondly if you have a sheet that uses many buttons mostly for navigation which would be the better route the macro with the button or the coded command. Trying to keep file size down. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button vs Command Button
Hi
Adding to Tom: Try a hyperlink, the blue underlined navigation thing as in a webpage. Insert Hyperlink menu. No code, intuitive user interface when done. HTH. Best wishes Harald "Dan" skrev i melding ... I have a workbook where I used a button and assigned the following macro: Private Sub T12_Click() Sheets("T1-05").Select Range("A17").Select End Sub In revamping the sheet I used a command button and loaded the code in to it. Works fine in the button, in the Command button I get a Run-time 1004 Select method of Range class failed. Why is this happen. A17 had data in it though it is linked from another sheet in the same workbook Secondly if you have a sheet that uses many buttons mostly for navigation which would be the better route the macro with the button or the coded command. Trying to keep file size down. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command button | Excel Discussion (Misc queries) | |||
Button vs Command Button | Excel Programming | |||
How to tab to a command button? | Excel Programming | |||
Command Button vs Control Button | Excel Programming | |||
Command Button vs Form Button | Excel Programming |