Posted to microsoft.public.excel.programming

Leigh Douglass[_2_] Leigh Douglass[_2_] is offline

external usenet poster

Posts: 11

Display VB code result in cell instead of message box?

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display VB code result in cell instead of message box?	Peter T	Excel Programming	0	May 7th 09 05:48 PM
Display VB code result in cell instead of message box?	Jacob Skaria	Excel Programming	0	May 7th 09 05:42 PM
display message while code is running	Bassman62	Excel Programming	5	November 10th 08 08:15 PM
Display message box after each line of code?	manxman	Excel Programming	2	April 26th 06 06:02 PM
UserForm - display text message then run code	Robert[_13_]	Excel Programming	3	September 13th 03 11:37 AM

All times are GMT +1. The time now is 07:08 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us