vba popup message code

**jpruffle** · 07-21-2008, 06:44 AM

Hi,

Can someone please advise me how I can have a simple popup message box that displays a range of cells (or list range). This is to be used as a reminder so for example I have an option - Top 10 product Yes | No then next to it I would like a hyperlink or similar that pops up with the list of the top 10 products as a reminder.

Any help would be greatly appreciated, thank you in advance.

JP

**royUK** · 07-21-2008, 08:06 AM

Where is this list stored?

**jpruffle** · 07-21-2008, 08:15 AM

The list is stored on another sheet, the list is named top10

Thank you

**royUK** · 07-21-2008, 08:39 AM

You can do this with a VBA userform & a listbox. Have you used VBA before?

**jpruffle** · 07-23-2008, 03:51 AM

Hi,

I have used vba before and have done a basic userform for adding data but never for extracting data can you guide me through it? Or point me in the right direction?

Thank you in advance,

JP

**royUK** · 07-23-2008, 04:24 AM

Use the Insert menu of the VB Editor to add a userform. Then add a Listbox from the Toolbox to he userform.
Populate he Listbox by using the named range and the userform's initialize event

Please Login or Register  to view this content.

You need to then decide how you want to load the form

**jpruffle** · 07-23-2008, 04:38 AM

Hi,

Thank you for the quick reply. I would like to call it using a button or a link can you advise how you call Private Subs?

Thank you again,

JP

vba popup message code

LinkBack

Thread Tools

Rate This Thread

Display

vba popup message code

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions