I would like to have the option to edit the standard data Entry form provided in excel, by adding 'Como box' selection, pull down lists, and even the Date picker. Is it possible to access and edit this standard 'excel' Data entry form?
Kindly let me know. Thanks
In which format shall i send you and 'example of my workbook'.
Shall i send the excel file complete ?. The file size is around 2,2 MB.
there are 11 separate sheets within the work book. I am using the standard off the shelf Excel Data entry form to enter data into 3 of these sheets.
kindly let me know
General rule for an example
Make sure there is just enough data to demonstrate your need.
Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.
Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
I need an example of the 3 sheets and where you want the comboboxes and what you want in the Comboboxes.
As agreed herewith please find attached the Excel 'Screen shots' ( same) of my Relational Database in Excel.
As you can see the 'standard Excel Data entry forms are good enough for me, although I would prefer to be able to click and select options in some of the boxes ( as a drop down list or combo box)
I thought the excel data entry form would allow me to edit this , but is not possible
I was trying to avoid having to design a whole form and VBA from scratch to tackle all the data entry
Any thoughts ???
Many Thanks in advance