me operator

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

In access I would use the Me operator (me!txtBox) to
refer to the form in focus and the element called txtBox.
I would like to make reference to the entire row where my
curser is placed in VBA code. Is there an equivalent
operator in Excel?
 
Try Activecell.Row

The "Me" operator does exist in Excel in User Form modules when referring to
objects inside their event procedures.
--
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com
 
Thank-you
-----Original Message-----
Try Activecell.Row

The "Me" operator does exist in Excel in User Form modules when referring to
objects inside their event procedures.
--
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com





.
Click to expand...
 
Robert Rosenberg said:
The "Me" operator does exist in Excel in User Form modules when referring to
objects inside their event procedures.
_______________________
Robert Rosenberg
Microsoft MVP - Excel
Click to expand...

Your advice is misleading. The Me keyword is used within a class to
refer to the current instance of the class (equivalent to the 'this'
keyword in C). The Me keyword is not limited to UserForms nor event
procedures.

--
 
Back
Top