Forms Feature

[gheyman]

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:

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.

 

[HaHoBe]

Hi gheyman,

what about using

'  set cursor into datarange like
  Range("B3").Select
  Application.CommandBars.FindControl(ID:=860).Execute

Ciao,
Holger

 

[RoryA]

It only works if the selection is within the top left few cells (can't remember the exact limits offhand) or your data set is named Database.