Textbox value to cell

[Hjemmet]

I need some Help to get Value from 16 differens Textbox to set value in Specific cell's
on my Userform12

textbox 1 to cell P7
textbox 2 to cell P8

and so on to Textbox 16

i have search around google but not find the answer i want

 

[Twollaston]

I need some Help to get Value from 16 differens Textbox to set value in Specific cell's
on my Userform12

textbox 1 to cell P7
textbox 2 to cell P8

and so on to Textbox 16

i have search around google but not find the answer i want

As far as i know you can take the text from a cell and put it in a text box, but not the other way around. Why not link all your textboxes to cells somewhere in the workbook, and then reference those cells when you need the value in the textbox

You can link a text box to a cell by inserting a text box(or edit text) and in the formula bar type = and then the cell reference you want it to be equal to

 

[My Aswer Is This]

Assuming you want to enter Userform Textbox values into active sheet try this:

Private Sub CommandButton1_Click()
'Modified  6/11/2019  4:02:20 PM  EDT
Dim i As Long
For i = 1 To 16
    Cells(i + 6, "P").Value = Me.Controls("TextBox" & i).Value
Next
End Sub

 

[Hjemmet]

I figure it out

by this code

Private Sub TextBox1_Change()    Range("P7").value = TextBox1.value ' specify the destination sheet and cell hereEnd Sub

and so on to my textbox 16

 

[My Aswer Is This]

And what was wrong with my code?
Put it in a Command Button and it will do all you want.

You gave no comment about my Help.

 

[My Aswer Is This]

Your script will enter the value immediately as you type

 

[Hjemmet]

When i try your code my textbox on my userform
aint put Data in the specific cell’s for each texbox
because you code put them into 1-16

Yes i got 16 textbox but with free space between them
like this first textbox cell P7 next P8 - P11 P12 next
P15-P16 and so on to textbox 16

 

[My Aswer Is This]

My script puts Textbox values into Column P Starting in Row(7)

And enters values down to Row 27

If there is a Problem it's because your TextBoxs are not TextBox1 to TextBox 16

I test all my scripts and can assure you it does not start in Row(1)

 

[Hjemmet]

My textbox is starting from 1 to 16
but i need Space between each value sæt in Row P for esch textbox
like
textbox 1 = P7
textbox 2 = P8

textbox 3 = P11
textbox 4 = P12

with space of 4 cell
and so on to textbox 16

 

[My Aswer Is This]

Well you said:

Row P

There is no Row P

There is a column P

And you said:

with space of 4 cell

Your example shows:


textbox 1 = P7
textbox 2 = P8

There are no 4 spaces here.​

_{^{<strike>
</strike>}}​