Excel macro, cant align value to centre

[dporrelli]

I have created a Macro which is a drop-down box with values (1,2,3,etc). It takes these values from a hidden sheet.
We are trying to have the values centred rather than aligned to the left. I have set the cell to centre and the values in the hidden sheet to centred also, but the value still remains aligned to the left, any ideas?

Thanks

 

[jges]

Is this a recorded macro or built from scratch?

If it was recorded when the hidden cell was formatted to left alignment, then the macro probably kept the original left alignment and is overriding your new format.

 

[SkipVought]

Hi,

You created a macro, but have us guessing at what has been recorded in your macro! ???

Please post.

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[combo]

It does not matter how the source range is formatted (and the code behind drop-down). Guess that you use a control from the 'Forms' toolbar, the font and alignment settings are not provided in this case.
For combobox from 'Control toolbox' toolbar, you can access control properties in design mode. The behaviour of this control is slightly different however.

combo