Copy Text in 1 userform textbox to a different userform textbox

Im just curious if anyone knows how to do this....Im trying to copy the number in Userform3 textbox 1 to Userform1 textbox 3.

So far Im using this, but its not doing anything ...

Please Login or Register  to view this content.

But that doesnt seem to work. any ideas how I could change that?

hey John

Thanks for the reply...I should have explained my bad...

Userform3 textbox1 is simply just a prompt that asks a user 'quantity'. Once the user enters the number it copys over to Userform 1, textbox3.

Does that make sense?

Originally Posted by john55

depends of what you want to do...anyway, it's funny!
so, if you have a value in textbox1-userform1, using yr code, it shows in textbox1-userform2

haha, nope, no joke, thats why Im asking. But whats above didnt seem to work, let me show you my code here:

Userform 1:

Please Login or Register  to view this content.

Userform3:

Please Login or Register  to view this content.

Originally Posted by john55

assuming this is not a joke...lol
try

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hey John,

Thanks again! So userform3 is triggered by a selection of a textbox. If a user selects 'Yes' userform 3 pops up. Which (its not a big thing to get userform 3 to appear)....

Moving the number from textbox1 in Userform3 to textbox3 in userform 1 appears to be the delimma. I used what was above, still had no luck. Would you like to see an example workbook perhaps?

Ill briefly explain what Im doing and who knows maybe their is a simplier way of doing what I need.....

So the user of this 'userform' selects from a drop down what kind of fruit they want, lets say they select 'apples'. The next part of the form asks the user, would you like to purchase multiple apples?
...If the user checks the, 'Yes', checkbox, a prompt comes up asking - "How many would you like to buy", the user enters the quantity they want to buy, and once they enter the quantity and hit submit the number gets moved over to userform 1, textbox 3.

Originally, I had a space on userform 1 for the user to enter the quantity, but the people requesting this application requested there be a prompt that appears and asks the quantity. Hopefully that makes sense.

Thanks again!

Originally Posted by john55

perhaps
UserForm1

Please Login or Register  to view this content.

UserForm2

Please Login or Register  to view this content.

Hey Norie,

Worked like a dream! Thanks pal!

I thought the only way to do this way to use a copy method from another userform. Thanks a bunch!

Originally Posted by Norie

If this is just for a single value couldn't you use an InputBox?

Please Login or Register  to view this content.

Hey,

I decided to post this question here since its pretty much related to the above question. I have a combobox as well with the third option being, <Enter a New Project Name> - and an inputbox appears. What I would like the user to be able to do is enter a project name, then that project name gets added to the combobox for future use. Right now - I have it so that the use can enter the project name, and it appears in the combobox while the userform is open, but say the user closes the userform, then re-opens it - the newly entered project name disappears. Is there a way I can add it to the combobox permanently....This is the code Im using to trigger the the inputbox:

Please Login or Register  to view this content.

And this is the code that populates the combobox when then userform initializes

Please Login or Register  to view this content.

Originally Posted by Norie

If this is just for a single value couldn't you use an InputBox?

Please Login or Register  to view this content.

Hey John,

I definitely see what your saying. I bet it does work, I probably just have something stupid in my code somewhere thats preventing it from working. but thanks for the help and suggestions. I know for the future at least how to copy the values incase I ever need to!

thanks a bunch

Originally Posted by john55

Hi,
perhaps in yr file it doesn't work, I know nothing about yr file, I just created a test file, used the above code-in accordance with yr request-and it copied the value of textbox1(UserForm1) to...it doesn't matter now!
the more information you give, the more solution(s) you get!

You know, I was thinking it had to be done that way to. Is there no way to do it without having to store a list on an excel sheet somewhere?
I suppose I can do it that way and just hide the sheet the list is being stored in. It would be more beneficial for company purposes if it could just be added to the list as I mentinoed above, but if there's no way to do that with vba then Im not going to waste time on it!

thanks pal

Originally Posted by Norie

If you want to add new projects you'll need to store a list of projects somewhere.

You would then change the code to populate the combobox from that list.

When a new project is added you would add it to the stored list and repopulate the combobox.

The only place itll ever need to be used is the Userform Im thinking. Because after these fields are filled out the primary purpose of inputting this data is to make a chart. But lets say I do use a list (list all the names in cells) - then as the 'Row Source' in the properties for the combobox I use the list name...That brings me to my next question (still related to the input box) - so as the very last selection in the list I put <Enter New Project> and again - if the user selects that option an input box prompts the user to enter the new project name... How do I always ensure that the input box will keep adding the new project names to the list in the excel sheet so that the combo box will always be populated with the new project names?

Originally Posted by Norie

Wouldn't it be more beneficial to have a list of objects stored somewhere?

It could be used in other places not just the userform.

Hey,

Thanks for the reply. What do you mean a list of objects do you mean declared somewhere in the VBA code, or do you mean literally a list of items in cells (Ie: A1 - Name of Project 1, A2 - Name of Project 2, A3 - Name of Project 3)?

Really my goal here is to allow the user to add project names to a combo box if the project name does not currently exist in the combo-box.

Originally Posted by Norie

Wouldn't it be more beneficial to have a list of objects stored somewhere?

It could be used in other places not just the userform.

Hey,

Sorry for the late reply, I didnt see the message. I re-read what I put up there it was kind of confusing. So from my understanding you suggested instead of me populating the combo box this way:

With Me.ComboBox1
.Add Item "Project 1"
.Add Item "Project 2"
End With

That I list the projects in rows in an Excel sheet, so for example in worksheet 1
A1 Would have > "Enter New Project"
A2 Would have > "Name of Project 1"
A3 Would have > "Name of Project 2"
A4 Would have > "Name of Project 3"

So I decided to take your suggestion and make a list in an excel sheet and populate the combo box that way. So now Im populating the combo-box by going in the 'Properties' window for the combo box and under > 'Row Source' speecifying a list name (I call the list name projects).

Now this is where my question comes in....Say a user selects 'Enter New Project' from the combo-box...I can get a prompt to come up asking the user to enter the Name of the new project ....but now do I get that input box to add the project name the user enters to the list of projects on the excel sheet?



Hopefully that makes sense, let me know.

Originally Posted by Norie

You've kind of lost me I'm afraid.

What do you see as an alternative to storing, somewhere, the list of projects?

If you wanted to alter the code so the 'list' was hard -coded then things are going to get pretty complicated.

Im able to get the input box to write to a cell now ....Now Im just trying to work on making the list I made dynamic. The list is named "Project", I tried adding this code, but it doesnt continuously expand the list as project names are added:

Please Login or Register  to view this content.