LinkBack URL
About LinkBacks
Hi folks
New to VBA and this forum, please be forgiving if I make any faux pas (and for my lack of VBA knowledge).
I have a workbook where the workflow is; add a new sheet, insert data into that sheet and then click a CommandButton (Start here) to draw that new sheet's name into a combobox1 where it can be selected. Combobox 2 is simply a choice of department. Then the next CommandButton (log session) activates that new sheet (that which was chosed in Combobox1, does text-to-column on it, and pastes certain of these columns into an Analysis sheet. I also need to register the combobox results into a list on a Session List sheet.
This was all working fine until yesterday. I made the session list a table, as I have a formula in the first column that I wanted to autofill when new data is added to the next row. I thought it was the fact that I had changed it to a table, as opposed to a range as specified in my code, but now that I have converted the table back to range it still doesn't work and I'm at my wit's end trying to find out why. Any help would be appreciated.
Side note: It tells me opening and repairing when I open the file due to it freezing yesterday... could it be that the file is corrupt and thus code isn't working? I have not attached the file, as I now can't even open it and will have to redo it (luckily have a copy of the code in text file so I can use this as a basis)
I am trying to avoid setting objects etc as i understand zero of that dim stuff.
I have set sheet names with Code Names (ie InputsCN) to avoid errors if the user changes the sheet names
Please Login or Register to view this content.
Register To Reply
Bookmarks