Damocles2021
New Member
- Joined
- Mar 6, 2021
- Messages
- 4
- Office Version
- 365
- 2016
- Platform
- Windows
Hi
I would appreciate some help, I have a spreadsheet named ‘Visits’ which has approx 400 columns (B–OC) and Names in Columns A2 – A36, data is entered into the userform which is then transferred to the sheet, I have 1 combox on the form, ‘cboName’ (populated with data from Column A) and 2 textboxes –‘txtSite’, Which is the header for the Columns, and ‘txtDate’. So user choses their name from (cboName) dropdown and then types the site name and date in textboxes, after pressing enter I would like the date to be entered in the cell relating to the site and name. If the sheet only had a few columns it wouldn’t be an issue but 400 odd columns!
If possible pointers in the right direction would help, I’m relatively new to learning VBA and enjoy the challenge of trying to work it out for myself, waiting for delivery of Microsoft Excel 2019, VBA & Macros) Googling just seems to throw up how to fill text boxes in user forms or how to find last row, or how to insert row etc, which I know how to do. (The thing what I have learned though is that there seems to be various methods to get the same results, ?. Even had trouble wondering what to name this thread title as!! ?)
Any and all help greatly appreciated.
Regards
Dam
I would appreciate some help, I have a spreadsheet named ‘Visits’ which has approx 400 columns (B–OC) and Names in Columns A2 – A36, data is entered into the userform which is then transferred to the sheet, I have 1 combox on the form, ‘cboName’ (populated with data from Column A) and 2 textboxes –‘txtSite’, Which is the header for the Columns, and ‘txtDate’. So user choses their name from (cboName) dropdown and then types the site name and date in textboxes, after pressing enter I would like the date to be entered in the cell relating to the site and name. If the sheet only had a few columns it wouldn’t be an issue but 400 odd columns!
If possible pointers in the right direction would help, I’m relatively new to learning VBA and enjoy the challenge of trying to work it out for myself, waiting for delivery of Microsoft Excel 2019, VBA & Macros) Googling just seems to throw up how to fill text boxes in user forms or how to find last row, or how to insert row etc, which I know how to do. (The thing what I have learned though is that there seems to be various methods to get the same results, ?. Even had trouble wondering what to name this thread title as!! ?)
Any and all help greatly appreciated.
Regards
Dam