Display VB code result in cell instead of message box?

Leigh Douglass

Guest

Posts: n/a

7th May 2009

Is it possible to get the result of the code below to show in a cell on my
spreadsheet instead of displaying in a message box?

Thanks
Leigh

Private Sub GetResult()
' counter
MsgBox -1 * (CheckBox1 + CheckBox2 + CheckBox3 + CheckBox4)
' binary encoded
MsgBox -1 * (CheckBox1 + CheckBox2 + CheckBox3 + CheckBox4)
End Sub

« THE "INSTR" FUNCTION !!! | Friday of a given week »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: Display VB code result in cell instead of message box?	Peter T	Microsoft Excel Programming	0	7th May 2009 05:48 PM
RE: Display VB code result in cell instead of message box?	Jacob Skaria	Microsoft Excel Programming	0	7th May 2009 05:42 PM
how to display the column or cell the MIN() result came from?	=?Utf-8?B?RmFkaQ==?=	Microsoft Excel Worksheet Functions	4	2nd Mar 2006 09:17 PM
display the cell that produced a result	=?Utf-8?B?SmVycnkgV29vZA==?=	Microsoft Excel Misc	1	6th Jun 2005 05:36 PM
How can I display a result as a cell name?	=?Utf-8?B?TG91Qw==?=	Microsoft Excel Misc	1	11th Feb 2005 05:53 PM