Hello everyone My name is Maurizio
and my problem is this:
I would like every time I finish inserting data into the TextBox placed inside a Userform.
I would like that in addition to inserting their data into certain Cells, these cells could be in turn Dordare di colre black in a format most often there is of the type (Border = Max)
a bit like I showed in the row (A2: F2) etc ...!
Thank you for all the help you want to give me about it
Just change your code from
Range("A2").Copia to Range("A2").Copy
Hello SunnyKow maybe I did not get well.
So the thing that I would like to solve is this:
1) I write the data inside the Textbox that are inside the Userform.
2) These data are already set in the columns that goes from the cell (A2: F2) and so far everything is OK
3) Then what I would like to get would be to: Create a function that matches every cell in every row with a black border = Max all here!
Thank you
Sorry, I don't understand your question.
Maybe you can give more examples and show us what is your expected results.
Hello SunnyKow I'm sorry if I answer you only now, but I've been very busy with my job.
Anyway: My problem is very simple Look at my last file, logically and only a draft of my real program, but already an idea of what I want to get.
Ahora being a Database I insert the data in a Userform with a lot of (Textbox) then I press a button and the data are put in cells starting from the Riga (A2: D2) and so far I have already done it.
the Problem and that I can not highlight the border of the cells that I fill with his data; A little like it happens in my little program that I have prepared you all here now.
Hello and Thanks again for everything
Hi Maurizio
From my understanding, you want to add some data in a range and then draw thick borders around the newly added data.
Hope I am correct.
Please refer attachment.
Hello SunnyKow Thank you so much it was just what I was trying to do but without succeeding; Without your help!
Thanks thanks thanks
Glad we could help
Thanks for your feedback.