h0l1yw0od
New Member
- Joined
- Oct 6, 2005
- Messages
- 21
Hi everyone,
Could someone help me with the code for an input box please.
I've got it to display the box but i need to put in the code that will send the input data to a cell on another page and add it to the figure already there.
The code i have so far is:
---
Dim NumberOfItems As String
NumberOfItems = InputBox("How many items were in the batch?", "Enter Amount.")
---
The sheet the figure needs to go to is Staff, cell A57.
Thanks,
Could someone help me with the code for an input box please.
I've got it to display the box but i need to put in the code that will send the input data to a cell on another page and add it to the figure already there.
The code i have so far is:
---
Dim NumberOfItems As String
NumberOfItems = InputBox("How many items were in the batch?", "Enter Amount.")
---
The sheet the figure needs to go to is Staff, cell A57.
Thanks,