View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jock Jock is offline
external usenet poster
 
Posts: 440
Default 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