Looking to input information on one userform and display it on the next one.

Hi,

New to this forum, relatively familar with programming concepts and logic however i am seeking the best way in going about creating a tool in excel which I have never done.

I am looking to create a small app that will contain a userform with some input forms such as text box's.

Then I am looking to press a create button and this information entered into the textboxes along with the label associated with it to be displayed on another userform in a formatted way which i can easily copy & paste such as using Ctrl+ C&V or a copy button, I should be fine creating buttons and trasnferring the info from the entry forms to the 2nd userform textbox but I am unsure how to include the labels associated.

As you can see in the current userform 2 has labels also but I found when I tried to copy and paste that these didn't copy, so now I am thinking of just creating one big text box but getting the label names from the first userform.

Any help would be much appreciated.

Hi

Welcome to the forum

Why would you need a second userform?

Once you have entered all your data why not just write it to your spreadsheet?

From now on please post your spreadsheet not pictures.

I sometimes get annoyed at having to duplicate someones work and then I do not respond.

As you are new I will help you as best as I can.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.


Ok this does what you want I think.

Please Login or Register  to view this content.

Originally Posted by mehmetcik

Hi

Welcome to the forum

Why would you need a second userform?

Once you have entered all your data why not just write it to your spreadsheet?

From now on please post your spreadsheet not pictures.

I sometimes get annoyed at having to duplicate someones work and then I do not respond.

As you are new I will help you as best as I can.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.


Ok this does what you want I think.

Please Login or Register  to view this content.

Thank you for your welcome & reply

I need a second userform as I am only looking to display the information & copy and paste it to another system, not enter it into a spreadsheet, I might look at that later as an added feature to store your notes but at the moment I am just looking to format it & allow the user to easily copy said output to another system.

So the first userform will allow me to enter the data, then output it to the second userform where I will have a copy button or for people that like to Ctrl + A, C, that functionality will be also be available. The reason I want it on a userform is because when the user exits the second user form the values of the labels will reset and the user can start again immediatley & as quick as possible.

Essentially a notes tool that I can use in a call centre environment for my note taking.

Also sorry for naiveness, when you say me.controls do you mean the name of my userform by saying 'me'.

Thanks again,

The server would not let me post into this post earlier.

I will try again

I cannot post my code.

Try the example attached.