Hi Guru's and Master's in Excel and VBA
In my workbook I created new tabs in based on the cell value in D3 and a macro attached to a command button.
The question is:
1. Is it possible to get Excel with vba or formula to check if the value D3.value is equal to any of my existing tabs? (Hope to avoid duplicates of tab names when i add the next one.)
2. If the value in D3 corresponds with any of my existin tabs, can i get a warning? Messagebox or D3's backgroundcolor turns Red?
3. If I change the value again in D3, can I get Excel to check name vs tabs again?
Hope to hear from you soon
Best regards
Golaidron
In my workbook I created new tabs in based on the cell value in D3 and a macro attached to a command button.
The question is:
1. Is it possible to get Excel with vba or formula to check if the value D3.value is equal to any of my existing tabs? (Hope to avoid duplicates of tab names when i add the next one.)
2. If the value in D3 corresponds with any of my existin tabs, can i get a warning? Messagebox or D3's backgroundcolor turns Red?
3. If I change the value again in D3, can I get Excel to check name vs tabs again?
Hope to hear from you soon
Best regards
Golaidron