Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating userform and filling it with data form row where userform is activate
I use a userform to mutate data in a sheet. I would like this userform to
be activated by a double click or press of button. The hard part is that I would like the fields in the userform to be filled with data mentioned on the selected row. For example: Cust.nr. Name phone age 1 Jan 1234567 20 2 Peter 1388431 25 3 Elco 3215687 30 I like peter's record to be mutated, so I would like to double click on ‘Peter’ to activate the userform. In this userform I want Peters current data already mentioned. My attempt of adding a button left of each row does not work. It does of course activate the userform but there is no record mentioning that ‘button on row 2’ was pressed. So the userform can not be filled with the data on row 2. I am out of clues. Can you help me? -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating userform and filling it with data form row where userform is activate
Hi
Put something like this in your userform module: Public Sub FillMe(R As Long) TextBox1.Text = Cells(R, 1).Value 'and so on End Sub and something like this in your worksheet module: Private Sub Worksheet_BeforeDoubleClick(ByVal _ Target As Range, Cancel As Boolean) Call UserForm1.FillMe(Target(1).Row) UserForm1.Show End Sub HTH. Best wishes Harald "Marthijn Beusekom via OfficeKB.com" skrev i melding ... I use a userform to mutate data in a sheet. I would like this userform to be activated by a double click or press of button. The hard part is that I would like the fields in the userform to be filled with data mentioned on the selected row. For example: Cust.nr. Name phone age 1 Jan 1234567 20 2 Peter 1388431 25 3 Elco 3215687 30 I like peter's record to be mutated, so I would like to double click on 'Peter' to activate the userform. In this userform I want Peters current data already mentioned. My attempt of adding a button left of each row does not work. It does of course activate the userform but there is no record mentioning that 'button on row 2' was pressed. So the userform can not be filled with the data on row 2. I am out of clues. Can you help me? -- Message posted via http://www.officekb.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating userform and filling it with data form row where userform is activate
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating scroll bars in a text box on a userform | Excel Programming | |||
button to activate userform | Excel Programming | |||
Activating a Userform in VB when changing Cells in Excel | Excel Programming | |||
Userform.Activate | Excel Programming | |||
Hide/Show modeless userform when activating/deactivating workbooks | Excel Programming |