View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default Set Button Caption

without knowing what EssVGetGlobalOption is it is hard to tell. I set x to 4
and 3 and it worked with both so it is probably this function you are calling.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Nigel" wrote:

I am trying to set button caption by using code but it is failing can someone
please point out what I should be doing

the error is Object Variable or With Block Variable not set



Dim mode As String
mode = EssVGetGlobalOption(5)
Set btn = Application.CommandBars.ActionControl
If mode = 4 Then
x = EssVSetGlobalOption(5, 2)
btn.Caption = "Warnings On"
Else
x = EssVSetGlobalOption(5, 4)
btn.Caption = "Warnings Off"
End If