Can this be done in VBA?

[thetexan1]

I want to create an excel test for persons wanting to apply for an excel position.

I want the test question to require the person to perform some given task in an actual excel spreadsheet (the programming will open excel with the sheet in question available)

What I want to know is...
1. Can this be done with VBA?
2. Does VBA have the functionality to test the results for proper completion?

For example...

If I want the person to Merge and center a range USING THE FORMAT DIALOG BOX rather than simply hitting the Merge and Center Button is there a way VBA can test to see that the range is indeed merged and centered AND that it was merged and centered by the specified method?

You don't need to get detailed here. I'm looking for basically a yes or no to those questions.

thanks

tex

 

[footoo]

Why not just remove the Alignment tab from the ribbon?

 

[James006]

Hello Tex,

What about a simple tailor-made UDF to return True/ False...?

HTH