[VBA] Finding the cell based on row and column values

[Trikson]

Hi Guys,

I am currently working on tool for my team that would enable them to add events to their projects, based on date.

Currently I have a following s/s:

	A	B	C	D	E	F	G	H	I
1	Project Calendar	2014-12-15	2014-12-16	2014-12-17	2014-12-18	2014-12-19	2014-12-20	2014-12-21	2014-12-22
2	project1
3	project2
4	project3
5	project4
6	project5
7	project6

<tbody>
</tbody>

I also have the userform where user can select the Project Name (combo box ProjectName_Box) from the list of projects, and select the date they want to create the event on (EventDate field auto-populated by clicking on desired date from MonthView calendar).

What I am struggling with is creating code that would pick these two values and find the corresponding cell. I.E. User wants to add new event for Project3 on 19th Dec 2014 so on the userform he selects Project3 from the dropdown list, and clicks on 19th Dec on MonthView calendar which populates the EventDate field with value: 2014-12-19. Now the code should take these two values then locate and select the corresponding cell - F4 in this current scenario.

Thanks in advance for any help.

 

[Trikson]

Just reverted the changes, and (what occurred to me only after Andrew's post) the month and day values in the format I enforced were switched - hence macro wasn't working. Fixed that and everything looks ok now - Thank you both for your assistance and sorry for my "newbiness"

PS. Is there an option in MonthView to generate message to the user if saturday/sunday would be selected (without hardcoding the dates)? Can't seem to find anything like that but wanted to check this with you.

 

[Andrew Poulsom]

You can use the Weekday function to test the day selected. Check it out in VBA Help.

 

[Trikson]

Just did. That's exactly what I've been looking for. Thanks!