ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating Pop-up Info Boxes (https://www.excelbanter.com/excel-programming/355299-creating-pop-up-info-boxes.html)

Aaron1978[_6_]

Creating Pop-up Info Boxes
 

Hi all,

In later versions of Excel when you start to type a function or a
statement (IF, AND, etc..) into a cell e.g. " =IF( " a little info box
appears giving you information about what you should be typing. Is
there anyway that you can make excel do this when you create your own
functions in VBA?

Best Regards,

Aaron


--
Aaron1978
------------------------------------------------------------------------
Aaron1978's Profile: http://www.excelforum.com/member.php...o&userid=31201
View this thread: http://www.excelforum.com/showthread...hreadid=519663


Bob Phillips[_6_]

Creating Pop-up Info Boxes
 
Click the = box to the left of the formula bar.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Aaron1978" wrote
in message ...

Hi all,

In later versions of Excel when you start to type a function or a
statement (IF, AND, etc..) into a cell e.g. " =IF( " a little info box
appears giving you information about what you should be typing. Is
there anyway that you can make excel do this when you create your own
functions in VBA?

Best Regards,

Aaron


--
Aaron1978
------------------------------------------------------------------------
Aaron1978's Profile:

http://www.excelforum.com/member.php...o&userid=31201
View this thread: http://www.excelforum.com/showthread...hreadid=519663





All times are GMT +1. The time now is 11:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com