Select a certain cell(base on condition) once a form button is clicked.

**miss_chloe** · 11-29-2015, 04:44 AM

The table is just a random data i found to use as an example. I want a code to be put on the macro to select cell B36 after clicking the button "East". Note that it will not be B36 anyore once i click West, it will be B42.

Attachment 432778

**LeoTaxi** · 11-29-2015, 05:25 AM

1 code for east en 1 for west

Kind regards
Leo

**miss_chloe** · 11-29-2015, 05:26 AM

I forgot to enable macro on attachment excel file. Please see the one below.

macro1.xlsm

**miss_chloe** · 11-29-2015, 05:35 AM

Thank you very much. It works.

Select a certain cell(base on condition) once a form button is clicked.

LinkBack

Thread Tools

Rate This Thread

Display

Select a certain cell(base on condition) once a form button is clicked.

Re: Select a certain cell(base on condition) once a form button is clicked.

Re: Select a certain cell(base on condition) once a form button is clicked.

Re: Select a certain cell(base on condition) once a form button is clicked.

Thread Information

Users Browsing this Thread

Similar Threads

Select spreadsheet after Contro Button clicked

select entire row of clicked cell in a table

[SOLVED] How to pop a form when clicked on cell

[SOLVED] Select column A's cell in relation to the row that macro button was clicked on?

[SOLVED] Macro To Open A Hidden Worksheet When Button (Form Control) Is Clicked

Showing preset Worksheets when Cmd Button clicked in user form

Using a Form Button to add 1 to a cell each time it is clicked

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions