Using existing lists/drop-down options/Excel formulas in Userforms

[agent_maxine]

After hours of searching for this topic with not much success, I thought I'd ask the question here.
I have a giant spreadsheet that contains many formulas, Excel tables and other references. In order to make it more user-friendly, I decided to create the Userforms to centralize all the data entry point.

1. Entry into ComboBox1 is to be mapped to Cell A1. Cell A1 currently contains a list from Excel Table 1, Column 1 ("Table1[Column1]").
2. Entry into TextBox2 is to be mapped to Cell B2. Cell B2 currently is a Vlookup formula that grabs the default/suggested value, but users can change them. I would like to have these vlookup values as the default entry of TextBox2, but open so that users can amend them. (Note: This is a Vlookup based on value that would be entered by users at the same time, just a few textboxes above).
3. I would like to have "Submit" (Save/Close) and "Cancel" (Don't Save/Close) command buttons at the bottom. I would also like a command button on the Worksheet ("Sheet1") where users can click to add/edit the previously entered info in Userforms. Is there a way to do this without assigning the cell values to each text-boxes/combo-boxes individually? I have 1 spreadsheet per client so there is no need to worry about growing number of rows, however the Userforms have approx. 100 fields so it would be a bit of pain to have to map them one by one!

Thank you muchly in advance for your kind assistance and expertise

 

[Flenda]

Your excel formulas are so useful. Thank you for sharing. I really need it for my job
__________________________________________________________________
“Reality continues to ruin my life.” - Utkarsh Classes Jodhpur apk