I would also like to be able to edit/update the form and update the information on the speadsheet accordingly. What I want to do next is click on the surname on the speadsheet and call up the userform with the fields complete for that person. I have the following code to put data from a VBA userform into Excel I'll post up further comments as I am trying to work my way through it! Personally I think this is a really tricky challenge and any help with doing this would be extremely appreciated. then user should then be able to select an item and the cells on the user entry screen would then get populated. the user then, depending on which item clicked, then gets shown the next window with a table and info on it. Once the user selects the cell shown in the example sheet, it should then bring up the user form.

the next sheet is the tables sheet where my tables are held. One sheet is the user entry sheet called User Entry Screen. I have an example excel sheet where I have 2 sheets. I would also like the user to select a row on the table and then be able to bring up another table depending on the row selected.basically so that the user can draw deeper into the information that they require. The user should then be able to select a particular row and insert it into the specified cell. I have been tasked with introducing userforms into an excel sheet and tbh I'm quite amazed that excel has this capability of adding userforms to excel sheets.Īnyway, I have 2 columns of data in an excel sheet and I wish to add this to a userform so that the userform displays the 2 columns beside each other with headings, like a table. 'Place the code below into the standard module 'Place the code below into the userform module Macro executed with CTRL-AĪnswer: Insert the following code in the appropriate modules. Question: Selection of sheet with UserForm-ComboBox. Subject: Select worksheet with UserForm-ComboBox. Everthing that I have on the instructions are below Are further steps needed that are missing from the instructions. I'm new to programing what am I leaving out. When I select debug 'frmSelect.Show' in module1 is highlighted. I close VBA and all I get when I run the macro is ' Runtime error '424''.

I paste the standard module code into a standard module also. I right click and select view code, then paste the userform code. I inserted the code for the userform module as instructed. I have followed the instuctions below from the 'Holy Macros! It's 2,500 VBA Examples' on cd.

2500 excel vba examples