Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display VB code result in cell instead of message box?
dim myCBoxes as long
myCBoxes = -1 * (CheckBox1 + CheckBox2 + CheckBox3 + CheckBox4) Range("A1").value = myCBoxes Another way without code way would be to assign the linkedCell property of each checkbox to a cell, lets say A1:A4 respectively, and sum them =SUM(--(A1:A4)) array entered or not array entered =SUMPRODUCT(--(A1:A4)) Regards, Peter T "Leigh Douglass" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display VB code result in cell instead of message box? | Excel Programming | |||
display message while code is running | Excel Programming | |||
Display message box after each line of code? | Excel Programming | |||
Use VBA code to display message if combobox selection not in list | Excel Programming | |||
UserForm - display text message then run code | Excel Programming |