T
TeRex82
I am setting up, "Not Quite Developing yet" a User Form.
I am using Text Boxes and ComboBoxes
The Form is working fine, however, I would like to be able to scroll through
the worksheet whilst the form is on screen. I have 10 columns, with several
hundred rows.
This is the scope of what I am trying to achieve.
User initiates form, user can input new data to the next blank cell, by
using a Text box and List boxes..this all works ok.
I need the User to be able to scroll down the sheet, with the data appearing
on the row, returned to the form. These need to be view only as well, so user
is not able to accidently make changes.
It pretty much needs to work like the Standard Excel form, but with a few
more options..
"User can search, insert rows" is what I'm working on next
I have been searching forums, but cannot find the answers I need.
Many Thanks
TerryH
I am using Text Boxes and ComboBoxes
The Form is working fine, however, I would like to be able to scroll through
the worksheet whilst the form is on screen. I have 10 columns, with several
hundred rows.
This is the scope of what I am trying to achieve.
User initiates form, user can input new data to the next blank cell, by
using a Text box and List boxes..this all works ok.
I need the User to be able to scroll down the sheet, with the data appearing
on the row, returned to the form. These need to be view only as well, so user
is not able to accidently make changes.
It pretty much needs to work like the Standard Excel form, but with a few
more options..
"User can search, insert rows" is what I'm working on next
I have been searching forums, but cannot find the answers I need.
Many Thanks
TerryH