cant get userform label to display cell value

**justaguyfromky** · 05-30-2011, 03:28 PM

I have been searching forums and the web for an answer to this with no luck so far. I have an add-in that I would like to add a report popup for. I am using a userform to make this report. I want to use a cell value that changes once daily to populate. When I run the userform, the values do not show up. they just show "lable1".

Please Login or Register  to view this content.

I don't understand why the values are not showing up. Any help or insight would be greatly appreciated.

Thanks,

Rob

**mikerickson** · 05-30-2011, 03:32 PM

Are you clicking on Label8?

Also, the tag for closing a code block is [/code]

**tigeravatar** · 05-30-2011, 03:36 PM

justaguyfromky,

Like mikerickson said, you're code won't be run until you click on label8 of the userform. Additionally, I noticed you said that this is coming from an add-in. An add-in is basically just a hidden workbook, so if no workbook is specified for the code, the add-in will try to use its own hidden workbook. To avoid that, specify that the code should be run on the activeworkbook:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

**justaguyfromky** · 05-30-2011, 05:57 PM

The label click part of the sub showed up behind the private sub by itself somehow. This is my first add-in and my first userform, so I am still learning.

I want the form to pop up and display the cell values as soon as it opens without any user interaction if possible. Also, I dont know if it makes a difference, but the cells that I want to reference are formulas showing total week to date numbers.

**tigeravatar** · 05-30-2011, 06:03 PM

justaguyfromky,

Then you would need to use the UserForm_Initialize event. Code would look like this:

Please Login or Register  to view this content.

And no, that you're referencing cells containing formulas doesn't matter.

Hope this helps,
~tigeravatar

**justaguyfromky** · 05-31-2011, 08:22 PM

Thanks Tigeravatar, That works... But the value in the cell and the value on the userform do not carry the same format. I have numbers that represent cash and percentages that have only one or two numbers after the decimal point, but on the userform, it shows up with a long string of numbers afterwards. Can the numbers be rounded in the userform or does it not have the option. I couldnt find anything in the properties that would fix it.

**tigeravatar** · 06-01-2011, 06:24 PM

justaguyfromky,

The Round(number to round, round to this many digits) function can take care of that. For example, the following will round the value to 2 decimal places:

Please Login or Register  to view this content.

Just set the format for each label as necessary
~tigeravatar

**mikerickson** · 06-01-2011, 10:21 PM

You could use the VBA function Format in code like this

Please Login or Register  to view this content.

**justaguyfromky** · 06-02-2011, 01:11 PM

Thank you both for your input, I love this forum, I have learned so much from other excel programmers like you. Both answers worked. I appreciate your help.