View Full Version : Solved: 2 separate Range value inputbox
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?
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
Excellent. It works. I can work with this. Thanks Chabu.
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.