Hello All,
I by no means am a coder, but I can make things work with direction. :) I am hoping the experts here can help me.
I have created a userform (with the help of pieces of code here and there that I have found on the web) but i need some tweaks that I cant seem to make happen...
On UserForm 1 you can search for existing ticket, or enter a new one.
on UserForm 2 you can search for existing checklist to support your ticket (from UF1) or if a checklist is not started, you can create a new one.
Currently, you have to input your search # in the combox box and hit search, all result display on the UF1... from here, there is a CHecklist search box. it ONLY OPENS UF2.
I would like for it to OPEN UF2 and return search results based on the search # in the combox box of UF1...
if no checklist is found - then msg box "Checklist not found, Create a new one" ... if checklist is found i would like the details of the checklist to show on the UF2.
I have tried to upload the file, however, i am receiving an error.
i hope you all have suggestions without the file available.
thanks
S