BANDI MAHA
Member
Members
Forum Posts: 23
Member Since:
July 20, 2020
July 20, 2020
Offline
I hope we are always given health ...
Hy admin,,,
may I ask for help, I can't adjust the text thickness ,,,
I have searched it but I haven't found a way to bold the text as I want ,,,
there are also references that use the formula: =bold(....) but it doesn't work hihi,,,
I haven't got the code yet ,,,
Purfleet
England
Member
Members
Trusted Members
Trusted Members
Forum Posts: 414
Member Since:
December 20, 2019
December 20, 2019
Offline
BANDI MAHA
Member
Members
Forum Posts: 23
Member Since:
July 20, 2020
July 20, 2020
Offline
Hi Purfleet,
Please look in the file that I attached ...
I want to bold the words in cell B4 ... an example of the desired thickening result is in cell B11 ...
if possible the result is like an example ...
Let me translate the sentence that is in the file attached above ,,, : " today, Friday the ninth of January 2021
I went to Pak Jo's house for a work meeting and tomorrow Saturday, January 16, 2021
I have to go with my family for work holidays."
Some words in this sentence cannot be bolded because the sentence comes from the formula ,,, can be seen in cell B4
BANDI MAHA
Member
Members
Forum Posts: 23
Member Since:
July 20, 2020
July 20, 2020
Offline
as well as ask to correct the following code ...
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("ea26") = "" Then
Application.ScreenUpdating = False
Else
Sheets("form_modal").Range("J14:J21").Copy ' kode
Sheets("s.barang").Range("g43").PasteSpecial xlPasteValues
ActiveSheet.Range("G43:S45").AutoFilter Field:=1, Criteria1:=Range("ea26")
Application.ScreenUpdating = True
End If
End Sub
the target is sheets ("s.barang") range ae26,
if the range = "" , then nothing happens but if we type numbers 1, 2 and so on
it will automatically copy part of the range from sheets "form_modal" and paste them to sheets ("s. barang") and
immediately activate the filter with criteria from the range" ae26 "
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Tony Johlie
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 287
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Faraz Rafi
Anthony Blake
Jackb57
Ben Tooke
Kelsey Fennell
Jeffree Bunning
Jackie Memije
John Franzon
Darcie Clayton
trevor mir
Forum Stats:
Groups: 3
Forums: 24
Topics: 6873
Posts: 30123
Member Stats:
Guest Posters: 49
Members: 33672
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —