Userform label1 update based on Textbox value

greyangel123 · Jun 24th 2016

Good afternoon I trying to create a userform that has a label in it that adds textbox value together. Example: Lebel1.caption = textbox1 +textbox2 + textbo3 etc... would anybody be able to help me out with this?

skywriter · Jun 24th 2016

Re: Userform label1 update based on Textbox value

Try the attached file. :cool:

greyangel123 · Jun 24th 2016

Re: Userform label1 update based on Textbox value

This works perfect is there a way to add an extra step like:

Code

V = Worksheets(ActiveSheet.index + 1).Name


 vlookup("& textbox14& ",'" & V & "'!A4:F1000,5,false)+Val(Me.textbox1)+Val(Me.textbox1)

skywriter · Jun 24th 2016

Re: Userform label1 update based on Textbox value

You're asking me to answer a question without the benefit of your userform or the workbook with the data.

So the answer is, maybe.

greyangel123 · Jun 24th 2016

Re: Userform label1 update based on Textbox value

[ATTACH=CONFIG]69516[/ATTACH]
Please note the userform is a work in progress.

skywriter · Jun 24th 2016

Re: Userform label1 update based on Textbox value

What do you want me to do, where is the data I'm using, what do you want the answer to be?

Give me an example based on the data.

greyangel123 · Jun 27th 2016

Re: Userform label1 update based on Textbox value

forum.ozgrid.com/index.php?attachment/69537/

Here is a better example just follow what the userform says also the macro will pop up asking you to debug the macro due to the Vlookup formula.

Userform label1 update based on Textbox value

Participate now!

Share