Excel 2007 : Need to get textbox/Spinbutton to show 1 by default

**robnez** · 02-15-2012, 10:54 PM

sorry i dont have a sample sheet, but i just need textbox to show 1 when connected to a spinbox. i have it setup so it changes the value of the checkbox, and i know that i can set it up to have the value default to 1, but it doesnt show the default number in the textbox and it shows up as blank.

i appreciate the help if you can offer it!

**dilipandey** · 02-15-2012, 11:18 PM

Hi robnez,

See the attachment where controls seems to be working as outlined by you. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**robnez** · 02-16-2012, 05:47 AM

ok so now that i was able to get ahold of the sample book i was using i added a spinbutton when you click on the button. unfortunately that workbook wasnt what i was looking for, but i definitely appreciate the help. i didnt setup the macro to add-in the data into the worksheet since i can figure that out later, just want the default number to show up as 1 in the textbox when you click on the "Click to add Call Information!!!!!" button.

sample workbook macros.xlsm

**dilipandey** · 02-16-2012, 06:51 AM

Hi robnez,

See the attached workbook, where the text box has 1.
You can change it anytime by going to properties -> values. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**robnez** · 02-16-2012, 02:48 PM

hm. ok than im not sure what i was doing than. at work i have excel 2007, and i did just that, but it wont show the default number. you have to change it before it shows anything. i had it defaulted to 1, but it text box stayed blank. appreciate the quick reply :D

**dilipandey** · 02-17-2012, 12:21 AM

Hi robnez,

It is the default value OR Properties -> Value?

Regards,
DILIPandey

<click on below 'star' if this helps>

**robnez** · 02-17-2012, 04:23 AM

I just figured it out today. i didnt realize that i needed to set the textbox value to 1 to automatically show 1 when the macro runs. thanks for the help though! :D