First User Form needs help with using textbox input a variable in vba Macro

**capson** · 07-08-2015, 04:14 PM

Working on my first Userform, in it I am trying to use two textboxes as variables to be passed to a macro, can't seem to get how to do this

I uploaded a file with the form

Thanks

**Leith Ross** · 07-08-2015, 08:13 PM

Hello capson

What is the output supposed to look like? You did not include a sample in the workbook.

**capson** · 07-08-2015, 09:10 PM

Leith, I am trying to run the concatenation macro

If I hardcode

Please Login or Register  to view this content.

Then the macro works fine

I am trying to use the userform to input the dilemiters (I have them set to a default txtDelimiter.Value = ", " and txtDelimiterTo.Value = "|")

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**capson** · 07-08-2015, 10:34 PM

Still not working but maybe this is closer using Public variables

First User Form needs help with using textbox input a variable in vba Macro

LinkBack

Thread Tools

Rate This Thread

Display

First User Form needs help with using textbox input a variable in vba Macro

Re: First User Form needs help with using textbox input a variable in vba Macro

Re: First User Form needs help with using textbox input a variable in vba Macro

Re: First User Form needs help with using textbox input a variable in vba Macro

Thread Information

Users Browsing this Thread

Similar Threads

Change filepath in macro based on textbox in form input

i want to have a macro code change based on input from a textbox in a form

[SOLVED] user form to input data according to text in textbox and listbox

vba excel user form restrict input on user textbox

User form textbox message for input error

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions