Good evening all,
By way of introduction, my name is Stuart and I am a new member to this forum. I will post an introductory message after this, but I am unfortunately under some time pressure with this query.
I have a data validation list on the first tab of an Excel Workbook, which allows the user to select a language (English, Español, Francais etc.).
On the second tab, there are five cells that the user must input information in, in order to tailor the spreadsheet to their needs.
If the user selects a language on the first tab, then proceeds to input the five fields of information on the second tab, and then returns to change the language a second time, then I need the macro to run in a way such that it clears those five fields of data on the second worksheet, then updates/recalculates/F9s the workbook.
I don't have any prior experience with macros or VBA.
Thanks in advance.
Stuart
By way of introduction, my name is Stuart and I am a new member to this forum. I will post an introductory message after this, but I am unfortunately under some time pressure with this query.
I have a data validation list on the first tab of an Excel Workbook, which allows the user to select a language (English, Español, Francais etc.).
On the second tab, there are five cells that the user must input information in, in order to tailor the spreadsheet to their needs.
If the user selects a language on the first tab, then proceeds to input the five fields of information on the second tab, and then returns to change the language a second time, then I need the macro to run in a way such that it clears those five fields of data on the second worksheet, then updates/recalculates/F9s the workbook.
I don't have any prior experience with macros or VBA.
Thanks in advance.
Stuart