ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   UserForms - Viewing multiple entries in a text box. (https://www.excelbanter.com/excel-discussion-misc-queries/95175-userforms-viewing-multiple-entries-text-box.html)

TeRex82

UserForms - Viewing multiple entries in a text box.
 
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


All times are GMT +1. The time now is 03:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com