Posted to microsoft.public.excel.programming

joel

external usenet poster

Posts: 9,101

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Referencing a UserForm	Patrick C. Simonds	Excel Programming	3	September 7th 09 04:36 AM
Referencing a UserForm in a Module	Patrick C. Simonds	Excel Programming	2	September 2nd 09 08:40 PM
userform code for timestamp on w/sheet	TUNGANA KURMA RAJU	Excel Programming	2	April 2nd 09 03:15 AM
Referencing Userform Controls	JeremyJ	Excel Programming	0	January 10th 09 12:43 AM
Referencing code outside of current sheet	nemadrias	Excel Programming	2	June 29th 06 08:26 PM

All times are GMT +1. The time now is 06:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us