Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 24th, 2010, 01:52 AM
Authorized User
 
Join Date: Mar 2008
Posts: 74
Thanks: 2
Thanked 0 Times in 0 Posts
Send a message via ICQ to sektor
Default Pop-ups and arguments descriptions in VBA Function (Excel 2010)

I have created VBA function and want behavior as Excel's built-in functions have when I start typing in cell: arguments hint and pop-ups in case of enumerations. What do I do to get the same behavior?
 
Old May 27th, 2010, 11:03 PM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

Hi

Can you try if MacroOptions (http://vbadud.blogspot.com/2010/05/h...-to-macro.html) help you

Cheers
Shasur
__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)
 
Old May 28th, 2010, 04:52 AM
Authorized User
 
Join Date: Mar 2008
Posts: 74
Thanks: 2
Thanked 0 Times in 0 Posts
Send a message via ICQ to sektor
Default

I know this code, but the problem with MacroOptions is that it shows arguments and function descriptions only if I choose Functions -> Insert function. If I type function directly in cell, then neither function description nor arguments descriptions are shown. And also MacroOptions doesn't allow to register drop-down menu with enumeration. Is there any other way to add description?





Similar Threads
Thread Thread Starter Forum Replies Last Post
WorksheetFunction.Match function problem [Excel 2010] sektor Excel VBA 1 March 10th, 2010 06:22 PM
Balloon pop-ups Cyber Shiva Javascript How-To 1 June 18th, 2008 01:08 PM
Explanatory pop-ups / second window ... asearle XSLT 6 January 8th, 2007 09:12 AM
getting all pop-ups nerssi Javascript 3 March 7th, 2006 01:22 AM
Create text pop-up in VBA function jimmy_chu Excel VBA 0 December 10th, 2003 12:15 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.