![]() So basically everything is working fine to put the entries on the excel spreadsheet. 'this is for the submit button, when click, data are put on the excel sheet, may have to play with the A4 and the rows (1,0)ĪctiveWorkbook.Sheets("Ticket Tracker").ActivateĪctiveCell.Offset(0, 0) = Date 'this should be the first nodeĪctiveCell.Offset(0, 1) = Time 'this is the time nodeĪctiveCell.Offset(0, 2) = Environ("USERNAME") 'this is the person who enters the entryĪctiveCell.Offset(0, 3) = Textbox1 'this is the commend fields'ĪctiveCell.Offset(0, 4) = Textbox2 'this is the action taken 'this is to make sure that all fields are selected My workplace has access to Excell VBA only. Like to also have a XML file in C:\ to record whatever the person enters in the userform. Everytime that the person clicks on "Submit" button, the entry is added on a new row in the excel spread sheet. I made a userform that allows the person to enter entries in the excel spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |