Column Width With Userform

With the code in the topic below, it automatically expands the cells I enter data into the table manually.

but how can I do this when entering data with "useform"?

Thread

AutoFit Column Width Macro

Hi All, I found some code to automatically resize columns. It works great for anything I type into a cell, but will not work for data entered via a userform unless I subsequently click onto the column. Any help is appreciated... Thanks

creativespace

Jul 3rd 2010

Quote from Carim

Hello,

A very very small modification for your UserForm ...

Code

' Adjust Column Width
  .Columns("A:C").Columns.AutoFit

Thank you teacher

health to your hands

I have a question,

it doesn't shrink when i delete data and unfortunately it doesn't expand when i log in manually.

Quote from Carim

When you say:

it doesn't shrink when i delete data and unfortunately it doesn't expand when i log in manually.

Just manually re-type the last data in the last row in Column C

I didn't notice that detail

thanks

Sir, I think the working principle is as follows

"enter data manually"

I fill columns a-b-c and it expands automatically.

To collapse it, it is necessary to delete column a-b-c "in order".

"with user form"

It expands automatically when I enter data.

but when I delete the data the width stays the same.

Quote from Carim

Kullanıcı Formunuzda 'Ekle' ve 'Sil' için benzer sonuçlara sahip olmak için aynı çok küçük değişiklik

you again

great job again

I want to thank you again