+ Reply to Thread
Results 1 to 4 of 4

Need to create a pop-up window for showing the information after click on header.

  1. #1
    Forum Contributor
    Join Date
    07-27-2018
    Location
    Jodhpur, India
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 Pro 64-bit)
    Posts
    405

    Need to create a pop-up window for showing the information after click on header.

    Hi, Greetings!

    I've included a file with only two columns: one for serial numbers like 1,2,3, and so on, and the other for analysis headers. The bulleted analysis point is written in the row immediately below the analysis title. I have currently established the grouping for these analysis points (These analysis points will be linked with excel report as it will not be hand written analysis). But now I want to animate the row of conclusion analysis when I click on the analysis header. I have seen a video or dashboard on YouTube where someone designed a popup window to display the information. Can any expert assist me in learning how to achieve the same thing I needed? I shall be truly thankful to him for teaching me something new.

    PJ


    Learning One New Thing Everyday!

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Need to create a pop-up window for showing the information after click on header.

    Could you just confirm using the example you've provided what would appear when you click where?

    ie do you mean that if a user clicked A2 then B2 would be displayed in the message box? or B3? or something altogether different?
    If someone has helped you then please add to their Reputation

  3. #3
    Forum Contributor
    Join Date
    07-27-2018
    Location
    Jodhpur, India
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 Pro 64-bit)
    Posts
    405

    Re: Need to create a pop-up window for showing the information after click on header.

    Hello pjwhitefield. Thank you for replying on my post.

    ie do you mean that if a user clicked A2 then B2 would be displayed in the message box? or B3? or something altogether different?
    The hidden row/s that are now being grouped will be shown as a pop up if the user clicks on the header analysis item that is listed next to the sr no. Just get rid of the grouping for the hidden rows. I*want to click on the header name to display the conclusion comment (related to only that header name) in a pop-up message (size of the pop up message will be in good size and readable on screen).

  4. #4
    Registered User
    Join Date
    07-19-2022
    Location
    Hong Kong
    MS-Off Ver
    365
    Posts
    28

    Re: Need to create a pop-up window for showing the information after click on header.

    That's mean you only concern row 1 on selection.

    put the following code on the worksheet you need to handle

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] The pound sign £ showing as J in code window
    By kjg in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-16-2021, 02:03 PM
  2. Showing outlook window from excel
    By amphinomos in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2015, 09:48 AM
  3. [SOLVED] Seperating Header information from Detail information in Excel
    By drewan187 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 10-09-2014, 06:32 AM
  4. Variable name and value not showing in watches window
    By huckey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-21-2013, 03:10 AM
  5. When click on workbook... open in NEW window
    By Xx7 in forum Excel General
    Replies: 2
    Last Post: 10-05-2011, 04:40 PM
  6. Immediate Window not showing up below code window
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-21-2006, 08:10 PM
  7. [SOLVED] Project Window not showing up
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-18-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1