Hi all,
I'm trying to make a pop up box where the message information will change based on variables.
I have a database of multiple factors (the 3 I'm currently working with are (Project, report type, frequency) which are unique combination.
The summary page shows these 3 factors and several other via a drop down list of the project.
On the summary page I'd like to make it so if you check a tick box (can use multiple check boxes), a message box pops up with a statement/details associated to project,type,frequency.
Because these statement/details contains alot of text, i'd like to use the pop up to keep the summary page 'clean' and this info if's also required to be displayed.
I have developed the message box and linked to the check box (happy to run multiple check box per line of results returned) so far using youtube tutorials but struggling (with my limited VBA knowledge) to do the next step. maybe some variant of matchindex/sumproduct/if statement I'm not sure the best solution
I'm trying to make a pop up box where the message information will change based on variables.
I have a database of multiple factors (the 3 I'm currently working with are (Project, report type, frequency) which are unique combination.
The summary page shows these 3 factors and several other via a drop down list of the project.
On the summary page I'd like to make it so if you check a tick box (can use multiple check boxes), a message box pops up with a statement/details associated to project,type,frequency.
Because these statement/details contains alot of text, i'd like to use the pop up to keep the summary page 'clean' and this info if's also required to be displayed.
I have developed the message box and linked to the check box (happy to run multiple check box per line of results returned) so far using youtube tutorials but struggling (with my limited VBA knowledge) to do the next step. maybe some variant of matchindex/sumproduct/if statement I'm not sure the best solution
