show a value in a userform

hmk

Active Member
Joined
Jun 8, 2004
Messages
423
I set up a text box on my userform and in the properties window set the control source property to sheet1!a1. Whatever is in this cell will always be the value shown in the text box.

i have a userform for analysing my expenses.....
I did as u said on my userform......but it gives me msg telling
could not set the controlsource property. Invalid property value

however, i did the same thing on a new userform, it worked fine.

could u please tell me why ?

Thanm u
yours
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Ron Morris

Active Member
Joined
Oct 18, 2004
Messages
430
Hi,

Rather than using Sheet1!A1, name Sheet1!A1 in the Name box in Excel (upper left hand corner right above column A) to something like EXPENSES.

I am not totally sure but I think the Control Source does not like breaks in words without having the _ in between.

Not totally sure, but give it a try.

Ron
 

hmk

Active Member
Joined
Jun 8, 2004
Messages
423
Thank u

i tried it, but.................no

any idea is apprecited
yours
h
 

Forum statistics

Threads
1,147,623
Messages
5,742,209
Members
423,714
Latest member
ftp2jz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top