How to activate the Button as Activecell?

**AdiK** · 11-04-2016, 07:15 AM

Hello Guys,
I would like to know if there is any way to make the cell in which the button is inserted as the ActiveCell when i click the button?
Thanks in advance

**zbor** · 11-04-2016, 07:22 AM

Do you mean:

Sub test()
Dim ac As Range
Set ac = Range(ActiveCell.Address)

End Sub

**AdiK** · 11-04-2016, 08:30 AM

Unbenannt.jpg

Hi zbor,

Thanks for the quick reply. In the image u can see that there are three buttons. I want that, when i click any of these buttons, the cell in which the button is inserted should become the activecell. Loking forward for your guidance

Thanks in Advance

**zbor** · 11-04-2016, 08:40 AM

Ah, I see.

Assign this macro to a button:

Sub btn_position()
Dim btn As Object
Set btn = ActiveSheet.Buttons(Application.Caller)
 
With btn.TopLeftCell
   adr = .Address
End With

msgbox adr

End Sub

**AdiK** · 11-04-2016, 08:47 AM

Perfect!

Thanks a lott

**AdiK** · 11-04-2016, 10:19 AM

Hi zbor,

I have another similar question. When i use the Application.inputbox(), i select a value on the excel sheet. I want the selected cell to be the Activecell cell now. Is there a way to do it?

Thanks in Advance

**zbor** · 11-04-2016, 10:32 AM

This is a new question, not so simillar

Please open a new thread

How to activate the Button as Activecell?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How to activate the Button as Activecell?

Re: How to activate the Button as Activecell?

Re: How to activate the Button as Activecell?

Re: How to activate the Button as Activecell?

Re: How to activate the Button as Activecell?

Re: How to activate the Button as Activecell?

Re: How to activate the Button as Activecell?

Thread Information

Users Browsing this Thread

Similar Threads

Returning Activecell when pressing a button

[SOLVED] Move Button To ActiveCell

Set Button as ActiveCell

How to activate a past activecell

ActiveCell.Activate

ActiveCell and command button help

[SOLVED] how to know be button in activecell

Bookmarks

Bookmarks

Posting Permissions