Log In
Register
Home
June 26, 2016
Offline
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
VIP
Trusted Members
June 25, 2016
Offline
Just change your code from
Range("A2").Copia to Range("A2").Copy
June 26, 2016
Offline
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
VIP
Trusted Members
June 25, 2016
Offline
Sorry, I don't understand your question.
Maybe you can give more examples and show us what is your expected results.
June 26, 2016
Offline
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
VIP
Trusted Members
June 25, 2016
Offline
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.
1 Guest(s)
