gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,342
- Office Version
- 365
- Platform
- Windows
I just came across the "Forms" in the Ribbon feature in Excel and would like to use it. But I want to launch it from a button using VBA.
I tried recording the macro and it gave me this:
But it doesn't seem to work if I launch it from a button.
I get a Run-time 1004
ShowDataForm method of Worksheet class failed.
I tried recording the macro and it gave me this:
Code:
Sub Forms_Show()
'
ActiveSheet.ShowDataForm
End Sub
But it doesn't seem to work if I launch it from a button.
I get a Run-time 1004
ShowDataForm method of Worksheet class failed.