Cell value in a userform

[mtheriault2000]

Hello

How can i display the value of a cell in a userform?

Martin

 

[Diablo II]

ok lets say you have a textbox and lets call it textbox1 then you would type in the

Private Sub UserForm_Initialize()
textbox1 = Range("A1").Value
end sub

 

[mtheriault2000]

Hello again Diablo II

Private Sub UserForm_Initialize()
UserForm1.Show
Sheets("Sat_Sheet").Select
TextBox1 = RANGE("M1_H1").Value
End Sub

When run, the userform is displayed, but TextBox1 is not modified.

Quest continues

Martin

 

[Colin Legg]

Hi,

Remove the UserForm1.Show line from the userform's initialize event handler.


and then change this:

Sheets("Sat_Sheet").Select
TextBox1 = RANGE("M1_H1").Value

to this:

TextBox1.Value = Sheets("Sat_Sheet").Range("M1_H1").Value

 

[mtheriault2000]

OK, it work, I place the userform.show after the Textbox assignation value

Many thanks

I progress,,,, slowly,,,, but progress

Martin

 

[Diablo II]

put your userform1.show in a button by its self, the Private Sub UserForm_Initialize just tells the form what to do when it starts. i use it so that way when the form started it will fill the textbox with a value form a sheets cell. hhmm i have not seen the use of _ in a range i can not get the _ to work . will you wont from range M1 to H1 to show ? if so you may need a listbox , or set the textbox like this and if you wont the ranges after H1 like I1 J1 and so on you will need to add & then the next range to put space do & " " &
TextBox1.Value = Sheets("Sheet1").Range("M1 ").Value & " " & Range(" H1").Value

 

[mtheriault2000]

Hello Diablo

Just to clarifie

Range("Hi_M1") = High (value) in Market 1
Range("Lo_M4") = Low in Market 4


My range definition is ok

Have a great day

Martin

Martin