fill in celula de excel
Last Updated: Mar 22 2015 10:45, Started by
bogd1n
, Mar 21 2015 20:10
·
0
#1
Posted 21 March 2015 - 20:10
ceau
vreau in excel 2 chestii sa fac si nu stiu cum in momentul cand dau click pe o celula sa ramana colorata cand dau ctrl+c sa ramana colorata celula ma poate ajuta cineva? Private Sub Worksheet_Selectionchange(ByVal Target As Range) Cells.Interior.ColorIndex = 0 Target.Interior.ColorIndex = 10 End Sub codul asta coloreaza celula dar nu ramane colorata mersi |
#2
Posted 22 March 2015 - 10:45
Private Sub Worksheet_Selectionchange(ByVal Target As Range)
With Selection.Interior .ColorIndex = 10 .Pattern = xlSolid End With End Sub |
Anunturi
Bun venit pe Forumul Softpedia!
▶ 0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users