Forum

Banding the cells o...
 
Notifications
Clear all

Banding the cells of black color with the Max section

8 Posts
2 Users
0 Reactions
62 Views
(@a-maurizio)
Posts: 214
Reputable Member
Topic starter
 

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

 
Posted : 25/06/2018 12:28 pm
(@sunnykow)
Posts: 1417
Noble Member
 

Just change your code from

Range("A2").Copia to Range("A2").Copy

 
Posted : 25/06/2018 7:10 pm
(@a-maurizio)
Posts: 214
Reputable Member
Topic starter
 

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

 
Posted : 27/06/2018 11:41 am
(@sunnykow)
Posts: 1417
Noble Member
 

Sorry, I don't understand your question.

Maybe you can give more examples and show us what is your expected results.

 
Posted : 28/06/2018 7:22 pm
(@a-maurizio)
Posts: 214
Reputable Member
Topic starter
 

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

 
Posted : 02/07/2018 4:43 am
(@sunnykow)
Posts: 1417
Noble Member
 

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.

 
Posted : 02/07/2018 10:10 pm
(@a-maurizio)
Posts: 214
Reputable Member
Topic starter
 

Hello SunnyKow Thank you so much it was just what I was trying to do but without succeeding; Without your help!
Thanks thanks thanks

 
Posted : 03/07/2018 3:56 pm
(@sunnykow)
Posts: 1417
Noble Member
 

Glad we could help

Thanks for your feedback.

 
Posted : 03/07/2018 7:19 pm
Share: