Do I need to have two seperate codes, or can one do both?

sbrazil

New Member
Joined
Nov 23, 2009
Messages
30
Hi,

I was wandering if someone could help me with codes. In truth, I am hopeless.

I want to install a code which will enable me to widen the data validation dropdown menu temporarily to about 80. I want it so it widens when i click on the dropdown menu, but then goes back to it's normal size once i click elsewhere.

I also want it to work with another code i already have running, which is a zooming in code to 130. So do ineed to have two seperate codes - can this work, or do i need one code which does the two things?

So ideally one code which zooms in to 80, and opens a dropdown menu wider than the column is, would be perfect. Is this possible?

I would be very, very impressed if this is so and someone could help me with this.

Thankyou,
speak again soon,
Scott <!-- / message -->
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Forum statistics

Threads
1,214,944
Messages
6,122,387
Members
449,080
Latest member
Armadillos

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
Back
Top