Background VBA and Macros

[ExcelNUB1234]

Hello All,

I am trying to make a spreadsheet that tracks all open service work from multiple locations.

I currently have a table with all equipment that I am doing work on, along with status, who is working on it, date of arrival etc. I am using data validation to choose the equipment that needs repair work, and VBA code to be able to select multiple pieces of gear. Each sub works on its own, but every time I try to implement some new code of any type, all subs seems to stop functioning.

I have experience with Python, however, I am very new to VBA and am attempting to teach myself, and it seems as thought I can only have one sub per workbook? Is this common, or am I just not doing this correctly.

Any resources anyone can provide is much appreciated.

 

[JEC]

If you use change events, you can only use every event once per sheet.

However, there is no limit for normal subs(in a module). Click right --> insert module en there you go.