CommandButton sometimes causes an unspecified error

[ernief]

Hi
This is my first question.
I have a command button (SaveChangesBtn) that I wish to set focus to under certain circumstances. On many occasions the button works fine, but occasionally I get an unspecified run time error.
It is at the following point in the code

POpenIssuesRowID = r.Row - 1
Call GotoRecord(recordfound, POpenIssuesRowID)
SaveChangesBtn.Enabled = True
SaveChangesBtn.SetFocus

I have stepped through on numerous occasions but cannot see why it should set focus sometimes and not others, Any thoughts please
Regards
ernief

 

[lhartono]

I use Excel 2007,
there is no control property such as CommandButton1.SetFocus only CommandButton1.TakeFocus*******.
I think SetFocus only available in Visual Basic 6 Command Button.

 

[ernief]

I use Excel 2007,
there is no control property such as CommandButton1.SetFocus only CommandButton1.TakeFocus*******.
I think SetFocus only available in Visual Basic 6 Command Button.

I am using Excel 2016. I am surprised by your answer. when entering code and using Ctrl+space and start entering the name of the object (CommandButton) "SaveChangesBtn" followed by a full stop "." SetFocus is one of the events in the list. Perhaps this changed from 2007?

 

[lhartono]

Maybe. I just try Excel 2010 still the same.

 

[lhartono]

Office 2013 also none, so starting Office 2016.

 

[Jaafar Tribak]

Have you tried using SaveChangesBtn.Activate instead of SetFocus ?