Background VBA and Macros

ExcelNUB1234

New Member
Joined
Oct 18, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
  2. Web
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.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

JEC

Well-known Member
Joined
Aug 21, 2021
Messages
1,057
Office Version
  1. 365
Platform
  1. Windows
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.
 

Forum statistics

Threads
1,175,545
Messages
5,898,053
Members
434,690
Latest member
Shamsuddin M

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top