PDA

View Full Version : Solved: 2 separate Range value inputbox



wilg
05-14-2011, 12:53 PM
is it possible to have 2 separate range's return the result of an inputbox?

eg


activecell.value & Range("AS13").Value = inputbox ""

This particular code dosent work for me but is there a way to do this?

mikerickson
05-14-2011, 12:58 PM
What do you want to do?
Do you want the user to enter text into an input box and have that put in two cells?
Do you want the user to be able to enter two ranges into an input box?

or something else?

wilg
05-14-2011, 01:11 PM
I want user to input a number into input box and have that put into two separate cells.

Chabu
05-14-2011, 01:25 PM
Public Sub input2()
Dim inputString As String
inputString = InputBox("")
ActiveCell.Value = inputString
Range("AS13").Value = inputString
End Sub

wilg
05-14-2011, 01:37 PM
Excellent. It works. I can work with this. Thanks Chabu.