Make a list that shows up when a cell is clicked

**iiro** · 10-23-2018, 05:28 PM

Hi!

How can I make a list that shows up when I click a cell?

In other words, how can I hide A2:X20 cells inside A1 and when I click A1 all the data in A2:X20 appear back?

It's for a school project please help!

**Keebellah** · 10-23-2018, 05:52 PM

You cannot 'hide'all the data in a cell.
You can hide the rows using a doubleclick event but we don't do homework

**iiro** · 10-23-2018, 07:18 PM

Originally Posted by Keebellah

You cannot 'hide'all the data in a cell.
You can hide the rows using a doubleclick event but we don't do homework

Thanks but it isn’t for homework, it is an unnecessary gimmick that would work good on my art class. Hiding a picture made of cells then making it appear again so it doesnt take up all the space. And yes I need it in one sheet not multiple.

**Keebellah** · 10-24-2018, 02:20 AM

Weel, have you tried the doubleClick event?

Place this code in the worksheet vba

Please Login or Register  to view this content.

Then Double click Cell A1

Make a list that shows up when a cell is clicked

LinkBack

Thread Tools

Rate This Thread

Display

Make a list that shows up when a cell is clicked

Re: Excel List

Re: Make a list that shows up when a cell is clicked

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to make list box menus auto-display when cell is clicked?

[SOLVED] How to make a non-macro button/checkbox that when clicked will copy value out of that cell

#Value! shows in text box on top of chart until clicked on

[SOLVED] Load web image when cell holding URL is clicked/double-clicked

[SOLVED] code so that when a cell is clicked, a tick mark goes in the cell that was clicked

[SOLVED] Problem inserting a picture in Excel that ONLY shows when clicked

[SOLVED] How can I make the bar that shows the content of the cell visible.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions