Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select a cell/row
I have the following code and when the data form opens I want it to be on the
first record. I thought I could enter something like Range("A3").Select - just before the data form line but I get an error - Select method of range class failed. Private Sub CommandButton5_Click() Sheets("Internal Sales Report").Visible = True Sheets("Internal Sales Report").Select Application.Run "ShowDataForm" End Sub Most of you will know that I am fairly new at this so thought I was taking an educated guess! Guess I am not that well eductaed yet. -- Leanne M (Aussie) (Changed Display name from Leanne) United Kingdom (Don''t ask me what an Aussie is doing living in the UK!) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select a cell/row
I did it!
I thought about selecting the cell I want when I leave the sheet rather than when I enter it and this works. Sorry for wasting your time -- Leanne M (Aussie) (Changed Display name from Leanne) United Kingdom (Don''t ask me what an Aussie is doing living in the UK!) "Leanne M (Aussie)" wrote: I have the following code and when the data form opens I want it to be on the first record. I thought I could enter something like Range("A3").Select - just before the data form line but I get an error - Select method of range class failed. Private Sub CommandButton5_Click() Sheets("Internal Sales Report").Visible = True Sheets("Internal Sales Report").Select Application.Run "ShowDataForm" End Sub Most of you will know that I am fairly new at this so thought I was taking an educated guess! Guess I am not that well eductaed yet. -- Leanne M (Aussie) (Changed Display name from Leanne) United Kingdom (Don''t ask me what an Aussie is doing living in the UK!) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select a cell/row
United Kingdom
(Don''t ask me what an Aussie is doing living in the UK!) Well, there are worse places you could be !! <bg Pete |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select a cell/row
Most definatly! In all honesty though I love it here
-- Leanne M (Aussie) (Changed Display name from Leanne) United Kingdom (Don''t ask me what an Aussie is doing living in the UK!) "Pete_UK" wrote: United Kingdom (Don''t ask me what an Aussie is doing living in the UK!) Well, there are worse places you could be !! <bg Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
select cell value based on value in adjacent cell | Excel Worksheet Functions | |||
I cannot select a single cell or pull down cell contents | Excel Worksheet Functions | |||
Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) |