Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing Sheet from UserForm code
User types an "X" in a cell in Sheet!1, column AH.
This triggers code which will open Userform11. On this Userform are two command buttons. When CommandButton1 is selected, I need my code to reference the cell in column F on same row as the "X" was input but I don't know how to get it to do this as the code is in the Userform. Thanks, -- Traa Dy Liooar Jock |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing Sheet from UserForm code
You could declare a public variable in a General module (not in the userform,
not in the worksheet module). Public MyRow as long Then assign a value to that in your worksheet_change(???) event. myrow = target.row And use it in the code in your userform msgbox activesheet.cells(myrow,"F").value Jock wrote: User types an "X" in a cell in Sheet!1, column AH. This triggers code which will open Userform11. On this Userform are two command buttons. When CommandButton1 is selected, I need my code to reference the cell in column F on same row as the "X" was input but I don't know how to get it to do this as the code is in the Userform. Thanks, -- Traa Dy Liooar Jock -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing Sheet from UserForm code
If I understand your set up correctly, I think the cell reference you want
would be this... Cells(ActiveCell.Row, "F") So, if you had a Range variable that you wanted to set a reference back to this cell... Set MyRangeVariable = Cells(ActiveCell.Row, "F") -- Rick (MVP - Excel) "Jock" wrote in message ... User types an "X" in a cell in Sheet!1, column AH. This triggers code which will open Userform11. On this Userform are two command buttons. When CommandButton1 is selected, I need my code to reference the cell in column F on same row as the "X" was input but I don't know how to get it to do this as the code is in the Userform. Thanks, -- Traa Dy Liooar Jock |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing Sheet from UserForm code
Rowcount = activecell.row
Range("F" & rowCount) = "abc" "Jock" wrote: User types an "X" in a cell in Sheet!1, column AH. This triggers code which will open Userform11. On this Userform are two command buttons. When CommandButton1 is selected, I need my code to reference the cell in column F on same row as the "X" was input but I don't know how to get it to do this as the code is in the Userform. Thanks, -- Traa Dy Liooar Jock |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a UserForm | Excel Programming | |||
Referencing a UserForm in a Module | Excel Programming | |||
userform code for timestamp on w/sheet | Excel Programming | |||
Referencing Userform Controls | Excel Programming | |||
Referencing code outside of current sheet | Excel Programming |