Move names into a text box and pushing data back

tonywatsonhelp

Well-known Member
Joined
Feb 24, 2014
Messages
2,398
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
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,573
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
 

Watch MrExcel Video

Forum statistics

Threads
1,090,127
Messages
5,412,612
Members
403,434
Latest member
DavidCB

This Week's Hot Topics

Top