change data in the spreadsheet with the form

[marreco]

Hi

When Selecting the ComboBox1, and choose a city, and after typing a value in TextBox1, I would like to save changes the worksheet named "Base".

then I select the ComboBox1 City Texas, and I type in TextBox1 7.00 all names in the spreadsheet Texas reberá the value 7.00 in column "B"



Please see the attached
thank you!

Cross-Post
http://www.thecodecage.com/forumz/mi...heet-form.html

[StevenM]

You need something like:

Please Login or Register  to view this content.

In the code module with the userform.

[marreco]

was very good, I found impressive!

one more thing as I do to get the value like $ 7.00?

Thank you!!!

[StevenM]

My mistake, it should be TextBox1.Value and not TextBox1.Text.

Please Login or Register  to view this content.

[marreco]

I think I must have expressed myself wrong.

I need the spreadsheet céluas tenhm this format $ 7.00

even with your change something went wrong.

anyway, thank you

[StevenM]

The cell format for column "B" is set at "R$"#,##0.00, so are you wanting to change this format?

We can add:

Please Login or Register  to view this content.

For example:

Please Login or Register  to view this content.

Does that help?

[marreco]

Hi.

Still did not work out this code does what I want but need it, look in column "B" only those cells that have data, otherwise the code is running too long!

Please Login or Register  to view this content.