Thread: Display VB code result in cell instead of message box?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Leigh Douglass[_2_] Leigh Douglass[_2_] is offline
external usenet poster
  
Posts: 11
Default 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 QuoteReply With Quote