Userform question
 

Hello,

Been asking lots of questions lately. If you have time, I hav
another! Iv'e recently created a form that enters data on
sheet.....say in columns A - F. Column A is a list of ticket numbers.
Columns B - F are info pertaining to each ticket number.
Once the add button on my form is pressed, the data is entered into th
next empty cell. I would like to create another form that can alte
the data on the same sheet, but I would like to use a combobox tha
will alow me to scroll down Column A and pick which ticket number
want to alter. Thanks again for all your help

Ore

--
Message posted from http://www.ExcelForum.com

Userform question
 

You may want to look at Data|Form.

It's a built in menu item that may be sufficient for your purposes.


"Oreg <" wrote:

Hello,

Been asking lots of questions lately. If you have time, I have
another! Iv'e recently created a form that enters data on a
sheet.....say in columns A - F. Column A is a list of ticket numbers.
Columns B - F are info pertaining to each ticket number.
Once the add button on my form is pressed, the data is entered into the
next empty cell. I would like to create another form that can alter
the data on the same sheet, but I would like to use a combobox that
will alow me to scroll down Column A and pick which ticket number I
want to alter. Thanks again for all your help

Oreg

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson