CivilEngineerExcel
New Member
- Joined
- Feb 17, 2014
- Messages
- 5
Hi, I'm new to VBA so only have a basic understanding so please bear with me.
I need some help with this: I'm trying to set up a VBA userform that will input information directly into a spread sheet. All the user has to do is click the userform, add the info and click populate, and the entered data will automatically go into the right cell. I have a database of around 300 separate items, so the entry system needs to use a drop down list to select the right item, then input into the correct row.
There’s currently 300 or so items in the first column, followed by a further 300 columns to record the 300 or so bits of data required for each item. It’s very large and a lot of data to store due to the nature of what I’m doing.
I also need the userform to load up all previously entered data. For example, if a drop down list is used to select item number 10 in the list, the userform will then bring up all the previously entered info. This will allow me to edit the previous information before it is then input back into the spreadsheet.
I’ve tried looking at various codes and stuff but could really do with a step by step process of how to do (as I’d rather learn how to do it rather than just copy and paste). Any help will be greatly appreciated.
Hope that all makes sense.
Cheers
I need some help with this: I'm trying to set up a VBA userform that will input information directly into a spread sheet. All the user has to do is click the userform, add the info and click populate, and the entered data will automatically go into the right cell. I have a database of around 300 separate items, so the entry system needs to use a drop down list to select the right item, then input into the correct row.
There’s currently 300 or so items in the first column, followed by a further 300 columns to record the 300 or so bits of data required for each item. It’s very large and a lot of data to store due to the nature of what I’m doing.
I also need the userform to load up all previously entered data. For example, if a drop down list is used to select item number 10 in the list, the userform will then bring up all the previously entered info. This will allow me to edit the previous information before it is then input back into the spreadsheet.
I’ve tried looking at various codes and stuff but could really do with a step by step process of how to do (as I’d rather learn how to do it rather than just copy and paste). Any help will be greatly appreciated.
Hope that all makes sense.
Cheers
Last edited:
