tlc53
Active Member
- Joined
- Jul 26, 2018
- Messages
- 399
Hi there,
I would like 3x input boxes to popup asking the user for information. When I just add the code for the first one, it works fine. However, I get errors when I add the next two codes. How do I amend the code so that each box pops up one after the other? Thank you!
Sub ssFav()
Dim response As String
response = InputBox("1/3 Enter notes to client regarding Input tax..")
Range("D53").Value = response
End Sub
Sub ssFav()
Dim response As String
response = InputBox("2/3 Enter notes to client regarding Output tax..")
Range("D101").Value = response
End Sub
Sub ssFav()
Dim response As String
response = InputBox("3/3 Enter notes to client regarding Overall Balance..")
Range("D106").Value = response
End Sub
I would like 3x input boxes to popup asking the user for information. When I just add the code for the first one, it works fine. However, I get errors when I add the next two codes. How do I amend the code so that each box pops up one after the other? Thank you!
Sub ssFav()
Dim response As String
response = InputBox("1/3 Enter notes to client regarding Input tax..")
Range("D53").Value = response
End Sub
Sub ssFav()
Dim response As String
response = InputBox("2/3 Enter notes to client regarding Output tax..")
Range("D101").Value = response
End Sub
Sub ssFav()
Dim response As String
response = InputBox("3/3 Enter notes to client regarding Overall Balance..")
Range("D106").Value = response
End Sub