I am very new to VBA and Excel and i need to validate some really complex excel sheet. How do i begin.

[JainAbraham]

Hi All, this is my first post .

I am abit aware of how excel works using vlookup,etc functions but i have never tried my hands in Excel Macros and VBA. I am now required to create a highly complex data validation tool using VBA yet i have no clue how to start.

I really want to look at this as an opportunity yet i am kinda getting overwhelmed by it as i am not sure how to start. Some guideline would be great. I beleive i am good logically finding solutions but i feel very handicapped here technically .

please help, i know i may be sounding very vague here sorry about that.
Thank you.

 

[hiker95]

JainAbraham,

Welcome to the MrExcel forum.

What version of Excel and Windows are you using?

See if the below links will help you with data validation:

Excel Data Validation
http://www.contextures.com/xlDataVal08.html#Larger
http://www.contextures.com/excel-data-validation-add.html

Excel -- Data Validation -- Create Dependent Lists
http://www.contextures.com/xlDataVal02.html

i have never tried my hands in Excel Macros and VBA

See my most up to date list:

Training / Books / Sites as of 1/30/2014
http://www.mrexcel.com/forum/excel-...umber-statement-end-statment.html#post3706277

 

[JainAbraham]

thankyou for the super quick response and a very helpful response

What version of Excel and Windows are you using?

I'm using Excel 2010 and windows 7 OS

 

[hiker95]

JainAbraham,

Thanks for the feedback.

I hope you were able to find a solution in some of the above links.

You are very welcome. Glad I could help.

And, come back anytime.