Move names into a text box and pushing data back

tonywatsonhelp

Well-known Member
Joined
Feb 24, 2014
Messages
3,194
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Hi Everyone
So I need to get some names and make userform inputs
so heres what i need,

I have 5 Cells with headers and 5 cells which need readings

I have userform1

I want to take userform1 and Place the headers from Cells A10,C10,E10,G10,I10 to header boxes
Below the header boxes I have Input boxes,
I then want to take the values I input into these boxes into B11, C11 etc.

I quite good with userforms so if you have examples I can adjust it I just don't know where to start?
Thanks
Tony
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
If I understand you correctly, on opening the userform you want it to read in the values from A10,C10,E10,G10,I10 into five textboxes in the userform. On the form below each header textbox you have a textbox for the user to enter data in. Then on pressing the OK button, this data gets transferred into the corresponding cells on row B.

The next time you use the form, are the data still to be added to row B, or to the next free row?
Do you want to load in the previous data as well (the old row B or the last row so far) or have the boxes empty?

1574244842321.png
 
Upvote 0

Forum statistics

Threads
1,215,029
Messages
6,122,755
Members
449,094
Latest member
dsharae57

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top