how come if I click my combo box or command button the size becomes bigger

**VBcielle** · Jan 7th, 2009, 05:20 AM

is there a way so that command button or combo box sizes will not change if i click the button

**Siddharth Rout** · Jan 7th, 2009, 05:41 AM

It shouldn't change. Where have you placed the controls and how have you placed them? A screenshot would definitely help

**VBcielle** · Jan 7th, 2009, 07:06 AM

it's inside the excel sheet. how can i disable it so that user's will be able to resize?

**Hack** · Jan 7th, 2009, 07:13 AM

How can you disable what so the users can resize what?

**VBcielle** · Jan 7th, 2009, 07:58 PM

resize the command buttons and combo boxes

**Siddharth Rout** · Jan 8th, 2009, 05:34 AM

Like I said a screen shot would help....

**VBcielle** · Jan 9th, 2009, 04:03 AM

hello sorry for the late reply here is the screen shot..is it a virus?
why when i click a combo box or a command button it gets bigger

**Siddharth Rout** · Jan 9th, 2009, 06:37 AM

1) What is the zoom level of the document?
2) How have you added these controls?

**VBcielle** · Jan 9th, 2009, 08:13 AM

the zoom level is 100%...the controls is added from the forms toolbar it is an activeX combobox

**Siddharth Rout** · Jan 10th, 2009, 01:42 AM

Hmmm... Can I see your workbook?

**VBcielle** · Jan 10th, 2009, 08:48 AM

this is just a part of my workbook please check..sometime its ok..but when i use the mouse of my laptop it gets bigger

**Siddharth Rout** · Jan 11th, 2009, 01:02 AM

Okay, i checked it in the pc. It didn't happen with me but let me check this on the laptop and then I will get back to you...

Also I noticed that you are adding controls thru Menu

View=>Toolbars=>Forms

I would suggest that you use

View=>Toolbars=>Controls

Also in the workbook attached I see that you are using the combobox to display data that is in $A$252:$A$255. Instead of that I suggest you to use data validation. Check my signature for data validation.

**VBcielle** · Jan 11th, 2009, 08:22 AM

hello i am using View=>Toolbars=>Controls....is it a virus?

**Siddharth Rout** · Jan 12th, 2009, 05:26 AM

No it is not a virus and you are not using View=>Toolbars=>Controls. i have already checked that. Have you checked the data validation linked I provided

**VBcielle** · Jan 12th, 2009, 09:12 AM

hello no i havent used the data validation...i only got the issue on comboxes and command buttons..isnt it if im using combo boxes on view>toolbars>controls..

combo boxes will be like this =EMBED("Forms.ComboBox.1","")

on the transaction level combo box i a using that it is in L34..check pleas

**Siddharth Rout** · Jan 13th, 2009, 01:54 AM

1) Yeah I know that you haven't used data validation. I was suggesting you to use data validation drop boxes instead of comboboxes.

2) When you right click on the controls created with view>toolbars>controls, it doesn't give you the option of "assign macro" see picture attached whereas your combo does it...

**VBcielle** · Jan 13th, 2009, 02:31 AM

how about with the Pal line combo box? the one that is resizing when clicked is there a way? i coded my sheets using combo boxes not the dropdown..

**VBcielle** · Jan 13th, 2009, 02:32 AM

what's the thing in format control and set dont move and resize? will that help?

**Siddharth Rout** · Jan 14th, 2009, 03:35 AM

Ok I have checked the file in my laptop as well. No difference in size.....

Nothing wrong with PAL either. See picture....

what's the thing in format control and set dont move and resize? will that help?

Thats for when you resize your cells do you want to resize your combobox as well.... No harm in trying.... but that is not the problem. As per your screen shot your combo is way toooooooo big

Also one more thing....

Right click the pal combo in design mode and click on format control. post a snap shot of "Size" tab

Edit: Sorry. forgot to attach the pic.

**Siddharth Rout** · Jan 14th, 2009, 03:48 AM

Ok try this... this might help.... delete that combo and create a new one....

**VBcielle** · Jan 14th, 2009, 03:53 AM

Originally Posted by koolsid

Ok I have checked the file in my laptop as well. No difference in size.....

Nothing wrong with PAL either. See picture....

Thats for when you resize your cells do you want to resize your combobox as well.... No harm in trying.... but that is not the problem. As per your screen shot your combo is way toooooooo big

Also one more thing....

Right click the pal combo in design mode and click on format control. post a snap shot of "Size" tab

Edit: Sorry. forgot to attach the pic.

thanks for the reply attached is the image... i dont know why i have that issue..yesterday it resizes again when i click the combo box

**Siddharth Rout** · Jan 15th, 2009, 04:10 AM

Did you try deleting it and recreating it?

**VBcielle** · Jan 15th, 2009, 04:27 AM

yes i did..still..resized

**Siddharth Rout** · Jan 15th, 2009, 04:43 AM

Then probably something wrong with the excel installation.... Like I said I tried it in my pc and laptop, it works just fine....

**VBcielle** · Jan 22nd, 2009, 10:09 PM

now...i have that again...what has to do with the installation?

Thread: how come if I click my combo box or command button the size becomes bigger

Thread Tools

Display

how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Re: how come if I click my combo box or command button the size becomes bigger

Posting Permissions