Fit barcode to merged cell width

Hi,

In this example which uses the Code 128 font, I have a Userform to auto fill cells C9, G27, C22 & G28 and these then populate cells G7, G9, G20 & G22 with barcodes using the font. The Userform is normally set to autorun so that users passwords are always hidden.

So that is the idea of how the file works, my question is...

As peoples usernames and passwords have varying lengths, is it possible to get the barcode to autofit the width of the merged cells?

I've tried to do a lot of research prior to asking but everything I have seen either says not to use merged cells (which means a complete redesign), or size cell to fit text, which also wouldn't work.

I'm guessing this will need VBA to adjust height of text to fit width of cells??

Any help greatly appreciated.

Originally Posted by ~TaC~

I'm guessing this will need VBA to adjust height of text to fit width of cells??

If you're saying that you want to fit in both height and width, then you are asking the impossible. Height and width of evey font, including barcodes are relative to each other (search font aspect ratio). If you change the height, the width will change with it and vise versa.

It can be done in word, but not excel (I spent a lot of time trying to find a way for something that I was doing).

Don't need height and width to fit, just width. Currently the height is much bigger than can be seen but this disappears out of cell height, I just want the width to adjust so that the width is always the same for every barcode displayed. Just so it looks more uniformed.

If it can't be done then it can't be done, I was just trying to find out.

Thanks for your reply.

You can format the cells as 'Shrink to fit' (shift ctrl f, then go to alignment tab), but I'm not sure how well this will work for what you need.

Sometimes its the simple things that matter lol.

I didn't think 'Shrink to fit' worked with merged cells but it seems to.

Thanks