select resource using message box

[theintern]

how would i code to prompt the user to select a resource from a list of a
message box, then save that resource to a variable and change it's calendar
in the resource sheet view?

thanks
scott

 

[Jack Dahlgren]

Build a userform with a combo box.
Populate the combobox with resource name and resource ID using additem while
looping through the resources or whatever list source you have
Write some code to handle the user selecting the item in the list which
stores the unique ID value
Use that value to identify the resource and modify the calendar.

There is a fair amount of code involved, but look at my article on
comboboxes (a bit more than halfway down the page) on my website and read
the rest of the stuff that is there. I think everything but modifying the
calendar can be found if you look closely enough.

http://zo-d.com/blog/archives/programming.html

-Jack Dahlgren

 

[theintern]

Beautiful. That is awesome. Thanks Jack!

Build a userform with a combo box.
Populate the combobox with resource name and resource ID using additem while
looping through the resources or whatever list source you have
Write some code to handle the user selecting the item in the list which
stores the unique ID value
Use that value to identify the resource and modify the calendar.

There is a fair amount of code involved, but look at my article on
comboboxes (a bit more than halfway down the page) on my website and read
the rest of the stuff that is there. I think everything but modifying the
calendar can be found if you look closely enough.

http://zo-d.com/blog/archives/programming.html

-Jack Dahlgren