Automated Ticketing for IT

Hi Guys,

Im not actually good in VBA that's why i need a help for those who are master in VBA macro. i have attached the screenshot of what i want to be in my form. i know how to make forms but the coding im not. please help.

on my form there are a combobox that listed all departments ie. ADMIN, Business Intelligence and MIS and when i click the GO ticket! button it will Generate the ticket number consists of MIS (depends on the choice department plus three zeros (000) then 1 (MIS0001)
ticket number is depending on the department choice.

on the textbox: the requested employee should enter only character not numbers (is it possible to have pop msg "wrong input" same with other textbox but in textbox where date need to fillout should contains date mm/dd/yyyy.. is this possible.

on the Remarks section with 3 optionbox whatever i choose with those 3 need to reflect on the summary worksheet.

and then lastly when i click the "put this info on the worksheet" should automatically update the summary spreadsheet.

Please do help me on this.

I dont know how to codes those forms.

many thanks,
albert

Hi Cheeky Charlie ,

I don't have access installed in my PC.

please do help me on this.