I've created a simple list with headings with dates and figures in UK formats (ie dd/mm/yyyy and £ signs).
I want the user to be able to press a button to call up a form to begin data entry. This can be done manually by selecting Data>Form which works fine but if I record these key strokes and attach the macro to a button, to automate the process the form that appears loses the UK formatting completely and reverts to US (although the data on the worksheet retains the correct format)
The recording of the macro generates the vba code Application.ShowDataForm. Now presumably I have to somehow add some VBA code to make it retain the UK settings and not revert to US. Is this a bug in Excel 97.
Any help would be much appreciated.
I want the user to be able to press a button to call up a form to begin data entry. This can be done manually by selecting Data>Form which works fine but if I record these key strokes and attach the macro to a button, to automate the process the form that appears loses the UK formatting completely and reverts to US (although the data on the worksheet retains the correct format)
The recording of the macro generates the vba code Application.ShowDataForm. Now presumably I have to somehow add some VBA code to make it retain the UK settings and not revert to US. Is this a bug in Excel 97.
Any help would be much appreciated.
