I did up a simple userform based rig to record attendances at various meetings in a hospital. I did it all on my work laptop which runs excel 2016. It was working beautifully so I sent it to my boss to get the final go ahead, and what happened when he clicked one of the command...
I have the following code below but for some reason I am getting the Run-time Error '1004'. Can anyone please help. I am not sure what this is related. Some information I found states its related to internet connection but I am connected to the internet.
Hello everyone! I am new to vba and have given myself a project to start learning. I am getting a run time error trying to use the match function. The code I have so far is:
Dim n As Double
Dim i As Integer, k As Integer, x As Integer
Dim wb1 As Workbook, wb2 As Workbook
Great title. Concise but long.
I have a VB script to move data from a particular tab on workbook A to the same named tab on workbook B. The macro button is on A's tab being copied.
The problem is that the default tab of workbook B is not where the pasting is going. The users need the workbooks...
I can create a combobox at runtime, additems, etc. But I can't seem to find a way to detect when that new box has been changed. I can read it if I click on another, pre-existing control, but that's not the intent. thx