View Single Post
 
Old 02-27-2024, 04:25 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,161
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

It doesn't matter if you aren't great with macros - there is plenty of resources available and threads here to help you learn.

I can't give you a direct answer because you haven't been clear on what you 'want'. This is a good thing because it shows you are trying to learn but it also means we can't jump to a complete solution without considering the larger picture.

Food for Thought: If you are going to validate a 'completed' form then you need to work out what constitutes completed. Does EVERY CC need to be completed or just some of them? If your code identifies a CC that needs completing, how does it inform the user where that CC is? When should the code run?

Here are some threads which are worth studying:
https://www.msofficeforums.com/word/...completed.html
https://www.msofficeforums.com/word-...-vba-code.html
https://www.msofficeforums.com/word-...ault-text.html
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote