X
Xhawk57
I have a worksheet with account numbers in column A and corecponding
information for those account numbers (customer name, type, balance, account
manager, etc) in each column. I have created a User Form in VB with text
boxes that correspond to the headings of blank columns that I have added to
the spreadsheet. what I would like to do is use the form to fill in the
information for each account number on the the sheet (the info would be typed
into the form and would fill the proper cell in the spreadsheet). I would
like this to happen for each account number, so as I complete the form for
one account number, it would move to the next account number's row and allow
me to enter the new information for that account number.
Any help on how to set up this form and link the information to the desired
cell would be greatly appreciated !
information for those account numbers (customer name, type, balance, account
manager, etc) in each column. I have created a User Form in VB with text
boxes that correspond to the headings of blank columns that I have added to
the spreadsheet. what I would like to do is use the form to fill in the
information for each account number on the the sheet (the info would be typed
into the form and would fill the proper cell in the spreadsheet). I would
like this to happen for each account number, so as I complete the form for
one account number, it would move to the next account number's row and allow
me to enter the new information for that account number.
Any help on how to set up this form and link the information to the desired
cell would be greatly appreciated !