Excel button to a sheet Solved

Question

Hello

Can someone help me create a button in Excel that I can click to go to a sheet?

And a small other question, how do I create a text box + a validate button to enter a value into a cell of a sheet? Thank you.

pijaku · Accepted Answer

Hello,
In Excel, display your controls toolbar (view/toolbars/controls).

Click on the "command button" icon.
Draw the button in the desired location.
Right-click on the button/command button object/Edit ---> change the button text.
Right-click on the button/Properties allows you to access a lot of little things like color (Backcolor), font, etc...
Double-click on the button, a window (VBA) opens with the following text:

Private Sub CommandButton1_Click() End Sub

write between these 2 lines:

Sheets("sheet name").select

like this:

Private Sub CommandButton1_Click() Sheets("sheet name").select End Sub

In the controls toolbar, click on the icon: "disable design mode"
and there you go

Mike-31 · Answer

Hi,

To navigate between sheets, you have a simple method, hypertext links.
For example, in column A, enter the names of your sheets and right-click on a cell/Hyperlink/select location in this document, click on the sheet to open (you can also choose the cell you want to activate), and so on for the other sheets. You can do the same on each sheet which will allow you to navigate.

You can also select your sheet from a validation list with a little VBA code involved.

With a button associated with a list or a series of buttons, each corresponding to a sheet.

For the follow-up question, please explain exactly what you want to do. I think you want to click on a button and a small dialog box allows you to enter text to fill in a cell, or you click on the button and the content of a cell is copied or cut to another cell.

See you soon!
Mike-31

A problem without a solution is a badly posed problem (Einstein)

hkahil · Answer

Thank you Pijaku for your explanation
I need another little help please
how can I create a dropdown list with the names of the cities
city1
city2
city3
and when I select city 1
I have a table that appears next to it, a table I mean my cells of 5 rows & 3 columns
when I select city 2 another table appears but instead of the previous one
it's like having a display box for previewing the values
thank you

pijaku · Answer

In that case, use the method suggested by Mike-31 regarding hypertext links. -- Whatever is worth doing is worth doing well.

hkahil · Answer

But actually, I managed to create the hyperlinks but the display doesn't happen in one single place
but in several different places
I created a link and I would like to know how to display cell Z3 for example or cell H5:Z3
that's fine, it's doable
but what I would like to do is to have a single display area and insert all my displays no matter which link I've clicked on.

Mike-31 · Answer

Re,

If you have already created your hyperlinks,
Right-click on the link Change Hyperlink, in the text box Enter the cell reference, enter Z3 or H5:Z3

See you +
Mike-31

A problem without a solution is a badly posed problem (Einstein)

hkahil · Answer

but the problem is that I have a list of links
when I click on the first link it takes me to the corresponding cell
the second link takes me to the corresponding cell too
but what I'm trying to do is have all my links direct to the same cell but just change the display

Mike-31 · Answer

Re,  I don't quite understand, do you want all your links to point to the same cell on the same sheet!  See you later Mike-31  A problem without a solution is a poorly formulated problem (Einstein)

hkahil · Answer

example
link 1
link 2
link 3

Table1
Table2
Table3

when I click on link 1, it shows Table1
when I click on link 2, it shows Table2
when I click on link 3, it shows Table3

but what I would like to do is have my links on the left in a dropdown list
and on the right an DISPLAY AREA FOR TABLES
when I click on link 1, I see Table1 displayed in the DISPLAY AREA FOR TABLES
when I click on link 2, I see Table2 displayed in the DISPLAY AREA FOR TABLES
always on the same page
that way I have a preview of my tables without changing pages and without having to scroll down to the bottom because I have plenty of tables

pijaku · Answer

Hi, Are your tables 1, 2, 3 fixed in number of columns and rows? If so, you can create 3 buttons that copy/paste the tables wherever you want. -- What is worth doing is worth doing well.

hkahil · Answer

Yes, my tables are fixed  How should I do that, but I would like to display all the tables in the right place according to the link I clicked

pijaku · Answer

Hello,
Let's assume that your table 1 is located in Sheet2 Range("AB136:AE146"); and you want it to appear in Sheet1 Range("A1:D11".
You create a small button (commandbutton1) and you type this code:
Private Sub CommandButton1_Click()
Sheets("Sheet2").Select
Range("AB136:AE146").Select
Selection.Copy
Sheets("Sheet1").Select
Range("A1").Select
ActiveSheet.Paste
Range("A1").Select
End Sub
Same for other tables.
--
What is worth doing is worth doing well.

Excel button to a sheet

12 réponses

How to get the character µ on the android keyboard.

Texture issues in enshrouded

Access issue to my "contact me" profile

Windows spotlight is not working.

My tv turns off and then on again repeatedly?

Executable from a python file

Pay in 4 installments cdiscount

The alt gr key is not working on my keyboard.

Code 80072efe how to get windows update working again

Video in ".3gp" format