I recorded a macro to open the Form on the Data Menu.
Sample Worksheet Attached
After starting the macro recorder I selected the Food table cell (located to the right
on the worksheet). Then went to the Menu bar.... Data Forms... and Clicked new.... followed by close and then stopped the
It produced the following code.... which reflects a code error when run.
What am I overlooking..... Thanks in Advance.
' McrEnterFood Macro
' Macro recorded 20/01/2010
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines