Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Closed Thread
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-15-2018, 12:57 PM
salimnore salimnore is offline Windows 7 32bit Office 2007
Novice
 
Join Date: May 2018
Posts: 8
salimnore is on a distinguished road
Default clicking on a cell to reveal a name

Hi all,



Thank you for taking the time to read my post, I am trying to click on a cell to reveal the names in a message box. I know this can be done using VBA. I have no experience in this and was wondering if there was an alternative or if someone can guide me with the vba with an explanation. My intention is to replicate this on a larger scale. I have attached an example of what i intend to achieve.


Thank you to all who help or comment.

Best wishes

Sam
Attached Files
File Type: xlsx names from a table.xlsx (11.3 KB, 1 views)
  #2  
Old 12-16-2018, 12:34 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,256
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Please do not post the same question on different sub forums. Thank you
Thread closed
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Closed Thread

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open an existing sheet by clicking on a cell in a master sheet darbybrown Excel 3 09-12-2016 05:12 PM
Help with a pop up window with relevant information upon clicking a value in cell Pvidya Excel 4 05-15-2014 04:58 PM
Help with a pop up window with relevant information upon clicking a value in cell Pvidya Excel Programming 2 05-15-2014 11:08 AM
A macro to reveal keyboard shortcuts assigned to global template? New Daddy Word 3 12-17-2013 07:08 AM
Can't cancel Reveal Formatting dave7777 Word 2 05-15-2011 01:18 PM


All times are GMT -7. The time now is 06:19 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft