VBA Excel Data Form that does not have the correct entry and fields

advertisements

I have the following VBA code, which should show a dataform from another hidden sheet.

Sub CoverageBssEntry()

   Application.ScreenUpdating = False
   Sheets("myhiddensheet").Select
   Range("myTable[#All]").Select
   ActiveSheet.ShowDataForm

End Sub

When I run this, the data form does not containt the labels and inputboxes of this table.

Any help is really appreciated, because it is driving me nuts! My only other option is to spend time to build custom made user forms, while this would do perfectly.


You cannot select a hidden sheet. And anyway the .Select statements are not necessary

Try

Sheets("myhiddensheet").ShowDataForm