Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting an active cell
Hello all,
I have a userform that is opened from a button on a worksheet. Private Sub range(A11).select frm_W2.show End Sub The userform is opened after cell A11 is selected because when the userform opens I want it to populate itself with the first record's data on the worksheet. The reason I don't select the cell in this sub is because I need to call this code up later to repopulate another record. frm_W2.tb_EIN.Value = ws.Cells(ActiveCell).Value frm_wc.tb_2.value = ws.Cells.Offset(0,1).Value and so on... I get a type mismatch with the first line. Can someone help with this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting an active cell
frm_W2.tb_EIN.Value = ActiveCell.Value
-- HTH... Jim Thomlinson "TimT" wrote: Hello all, I have a userform that is opened from a button on a worksheet. Private Sub range(A11).select frm_W2.show End Sub The userform is opened after cell A11 is selected because when the userform opens I want it to populate itself with the first record's data on the worksheet. The reason I don't select the cell in this sub is because I need to call this code up later to repopulate another record. frm_W2.tb_EIN.Value = ws.Cells(ActiveCell).Value frm_wc.tb_2.value = ws.Cells.Offset(0,1).Value and so on... I get a type mismatch with the first line. Can someone help with this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting an active cell
Cells normally takes a row,column argument. I just tried the following:
activesheet.cells(6,5).value = "san diego" from the immediate pane, but instead of 6,5 I used activecell and got a type mismatch error. When I substituted the above, it worked. HTH. "TimT" wrote: Hello all, I have a userform that is opened from a button on a worksheet. Private Sub range(A11).select frm_W2.show End Sub The userform is opened after cell A11 is selected because when the userform opens I want it to populate itself with the first record's data on the worksheet. The reason I don't select the cell in this sub is because I need to call this code up later to repopulate another record. frm_W2.tb_EIN.Value = ws.Cells(ActiveCell).Value frm_wc.tb_2.value = ws.Cells.Offset(0,1).Value and so on... I get a type mismatch with the first line. Can someone help with this? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting an active cell
Thanks for your help.
Is the second line of code correct? or should it be frm_wc.tb_2.value = ActiveCell.Offset(0,1).Value "Jim Thomlinson" wrote: frm_W2.tb_EIN.Value = ActiveCell.Value -- HTH... Jim Thomlinson "TimT" wrote: Hello all, I have a userform that is opened from a button on a worksheet. Private Sub range(A11).select frm_W2.show End Sub The userform is opened after cell A11 is selected because when the userform opens I want it to populate itself with the first record's data on the worksheet. The reason I don't select the cell in this sub is because I need to call this code up later to repopulate another record. frm_W2.tb_EIN.Value = ws.Cells(ActiveCell).Value frm_wc.tb_2.value = ws.Cells.Offset(0,1).Value and so on... I get a type mismatch with the first line. Can someone help with this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting cells on active row | Excel Discussion (Misc queries) | |||
Selecting active area of sheet | Excel Discussion (Misc queries) | |||
Selecting the active row | Excel Programming | |||
Selecting Previously Active Cell | Excel Programming | |||
Selecting Active Cell before Text Import Routine | Excel Programming |