Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
here is the syntax for the InputBox Method
expression.InputBox(Prompt, Title, Default, Left, Top, HelpFile, HelpContextId, Type) 0 formula 1 number 2 string 4 logical (True or False) 8 cell reference in the form of a Range object 16 error value, such as # N / A 64 array of values Dim rng As Range, dataname As String Set rng = Application.InputBox(prompt:="Do your selection in the summary page", Type:=8) dataname = Application.InputBox(prompt:="type the name of data", Type:=2) Me.TextBox1 = dataname Me.TextBox2 = rng.Parent.Name& "!"& rng.Address but i do not see why you can not used directly a texbox on userform -- isabelle |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code to Create Input Box To Select a File | Excel Programming | |||
create Macro €“ select data, sort by acc no., yr, part no, create P | Excel Programming | |||
Using code to create a control on an Excel userform | Excel Programming | |||
How to create in a userform, select all/deselect all checkboxes | Excel Programming |