Offset reference to a button

**KerahJoy** · 03-30-2022, 01:26 PM

Hello,

I have a button that runs a code and also timestamps. I am wanting timestamp to show in a cell that is relative to the button (cell to the right). I only see codes that are relative to a particular cell but not a button......

**Keebellah** · 03-30-2022, 03:37 PM

Hi, all you need to do is detect the cell the button is in sometime the left top corner and that tells you the address i=of that cell and then just fill in or calculate the offiset

**Artik** · 03-30-2022, 05:48 PM

As part of the test, assign the following macro to the button:

Please Login or Register  to view this content.

Artik

Offset reference to a button

LinkBack

Thread Tools

Rate This Thread

Display

Offset reference to a button

Re: Offset reference to a button

Re: Offset reference to a button

Thread Information

Users Browsing this Thread

Similar Threads

Indirectly reference the reference argument of an OFFSET function

ActiveX Control Spin Button Copy Button and Change Cell reference?

Excel2010:Spin Button Cell Link reference remains stubbornly in absolute reference format

Need help with OFFSET for 2 reference

Find and Offset Next Button

A button that creates a button that calls an offset macro

Offset Reference

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions