Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Strings from UserForm to Module
Using VBA, I want to collect a range from the user with a UserForm, and then pass the range string to a subroutine in a module. I can pass numbers in this fashion, but I am unsuccessful passing strings. Any suggestions?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Strings from UserForm to Module
Rather than suggest a way, why don't you tell us how you pass numbers, as
the technique for strings should be similar. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "John Kauffman" wrote in message ... Using VBA, I want to collect a range from the user with a UserForm, and then pass the range string to a subroutine in a module. I can pass numbers in this fashion, but I am unsuccessful passing strings. Any suggestions? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Strings from UserForm to Module
John,
Dimension a string as a public variable at the top of a codemodule: Option Explicit Public myStr As String Sub TryNow() Load UserForm1 UserForm1.Show MsgBox myStr Range(myStr).Select End Sub Put a RefEdit box on your userform - which is the best way to select a range, and then use something like this with a commandbutton: Private Sub CommandButton1_Click() myStr = UserForm1.RefEdit1.Text UserForm1.Hide End Sub HTH, Bernie MS Excel MVP "John Kauffman" wrote in message ... Using VBA, I want to collect a range from the user with a UserForm, and then pass the range string to a subroutine in a module. I can pass numbers in this fashion, but I am unsuccessful passing strings. Any suggestions? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Strings from UserForm to Module
Sub Main()
Dim sStr as String sStr = "A1:B30" mysub sStr End Sub Sub MySub(sStr1 as String) msgbox Range(sStr1).Address(External:=True) End Sub -- Regards, Tom Ogilvy "John Kauffman" wrote in message ... Using VBA, I want to collect a range from the user with a UserForm, and then pass the range string to a subroutine in a module. I can pass numbers in this fashion, but I am unsuccessful passing strings. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing array of strings from DLL function to VBA | Excel Programming | |||
passing strings | Excel Programming | |||
passing strings | Excel Programming | |||
Passing variables from module to userform | Excel Programming | |||
passing strings | Excel Programming |