![]() |
Filling/referencing cells from User Form
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 ! |
All times are GMT +1. The time now is 06:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com