Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Form/Highlight row
With this in a module Workbook:
Private Sub Workbook_Open() With Sheets("Sheet1") Application.Goto .Range("A2") .ShowDataForm End With End Sub I can open up my form automatically. I was wondering if row 2 could be highlighted on open and each row thereafter when you move up or down a row to edit data in the form's window? Any help would be apprecaited. TIA |
#2
|
|||
|
|||
I don't think you can do anything while that builtin Data|Form is running.
You could create your own UserForm and do anything you want, though. In fact, John Walkenbach has an enhanced dataform at: http://j-walk.com/ss/dataform/index.htm (and the code is available for a minor fee ($20 USA), if you want to modify it.) Ving wrote: With this in a module Workbook: Private Sub Workbook_Open() With Sheets("Sheet1") Application.Goto .Range("A2") .ShowDataForm End With End Sub I can open up my form automatically. I was wondering if row 2 could be highlighted on open and each row thereafter when you move up or down a row to edit data in the form's window? Any help would be apprecaited. TIA -- Dave Peterson |
#3
|
|||
|
|||
Thank you, John's download (thanks for posting that John)
worked fine. I just needed the row highlight to move. -----Original Message----- I don't think you can do anything while that builtin Data|Form is running. You could create your own UserForm and do anything you want, though. In fact, John Walkenbach has an enhanced dataform at: http://j-walk.com/ss/dataform/index.htm (and the code is available for a minor fee ($20 USA), if you want to modify it.) Ving wrote: With this in a module Workbook: Private Sub Workbook_Open() With Sheets("Sheet1") Application.Goto .Range("A2") .ShowDataForm End With End Sub I can open up my form automatically. I was wondering if row 2 could be highlighted on open and each row thereafter when you move up or down a row to edit data in the form's window? Any help would be apprecaited. TIA -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|