-
how come if I click my combo box or command button the size becomes bigger
is there a way so that command button or combo box sizes will not change if i click the button
-
Re: how come if I click my combo box or command button the size becomes bigger
It shouldn't change. Where have you placed the controls and how have you placed them? A screenshot would definitely help :)
-
Re: how come if I click my combo box or command button the size becomes bigger
it's inside the excel sheet. how can i disable it so that user's will be able to resize?
-
Re: how come if I click my combo box or command button the size becomes bigger
How can you disable what so the users can resize what?
-
Re: how come if I click my combo box or command button the size becomes bigger
resize the command buttons and combo boxes
-
Re: how come if I click my combo box or command button the size becomes bigger
Like I said a screen shot would help....
-
1 Attachment(s)
Re: how come if I click my combo box or command button the size becomes bigger
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
-
Re: how come if I click my combo box or command button the size becomes bigger
1) What is the zoom level of the document?
2) How have you added these controls?
-
Re: how come if I click my combo box or command button the size becomes bigger
the zoom level is 100%...the controls is added from the forms toolbar it is an activeX combobox
-
Re: how come if I click my combo box or command button the size becomes bigger
Hmmm... Can I see your workbook?
-
1 Attachment(s)
Re: how come if I click my combo box or command button the size becomes bigger
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
-
Re: how come if I click my combo box or command button the size becomes bigger
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.
-
Re: how come if I click my combo box or command button the size becomes bigger
hello i am using View=>Toolbars=>Controls....is it a virus?
-
Re: how come if I click my combo box or command button the size becomes bigger
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
-
Re: how come if I click my combo box or command button the size becomes bigger
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
-
1 Attachment(s)
Re: how come if I click my combo box or command button the size becomes bigger
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...
-
Re: how come if I click my combo box or command button the size becomes bigger
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..
-
Re: how come if I click my combo box or command button the size becomes bigger
what's the thing in format control and set dont move and resize? will that help?
-
1 Attachment(s)
Re: how come if I click my combo box or command button the size becomes bigger
Ok I have checked the file in my laptop as well. No difference in size.....
Nothing wrong with PAL either. See picture....
Quote:
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 :D
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.
-
Re: how come if I click my combo box or command button the size becomes bigger
Ok try this... this might help.... delete that combo and create a new one....
-
1 Attachment(s)
Re: how come if I click my combo box or command button the size becomes bigger
Quote:
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 :D
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
-
Re: how come if I click my combo box or command button the size becomes bigger
Did you try deleting it and recreating it?
-
Re: how come if I click my combo box or command button the size becomes bigger
yes i did..still..resized
-
Re: how come if I click my combo box or command button the size becomes bigger
Then probably something wrong with the excel installation.... Like I said I tried it in my pc and laptop, it works just fine....
-
Re: how come if I click my combo box or command button the size becomes bigger
now...i have that again...what has to do with the installation?
