Question description:
This user has given permission to use the problem statement for this
blog.
excel developer function
Private Sub Worksheet_Calculate()
Dim rg, cl As Range
Set rg = Range("G13:G19")
For Each cl In rg
If cl.Value = "SUSPENSION" Then
cl.Font.Color = vbRed
Else: cl.Font.Color = vbBlack
End If
Next cl
End Sub
Solved by C. B. in 58 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
12/12/2017 - 12:29
Thank you for choosing got it pro excel
Excelchat Expert
12/12/2017 - 12:29
How may I help you today?
User
12/12/2017 - 12:29
i need help with Excel developer
Excelchat Expert
12/12/2017 - 12:30
can you tell me more about that you specifically needed?
User
12/12/2017 - 12:32
how to make commands using the developer tab? e.g. design mode and visual basics tool. how do we script out what we want the database to do?
Excelchat Expert
12/12/2017 - 12:35
In the developer tab there is tab called insert where you can insert different commands they are mainly triggers to the vba codes
Excelchat Expert
12/12/2017 - 12:37
does that help you?
User
12/12/2017 - 12:37
what about the coding part? how do we code?
User
12/12/2017 - 12:37
is there any help online on coi
User
12/12/2017 - 12:38
codes*
Excelchat Expert
12/12/2017 - 12:39
do you have a file to share?
User
12/12/2017 - 12:40
i'm trying to create a database using these functions. currentlly trying to figure out how I am going to do this.
User
12/12/2017 - 12:41
i'm just stuck in the coding part under the visual basis tab
User
12/12/2017 - 12:41
I had a look at a sample database which used this function but I cannot understand the coding on it
Excelchat Expert
12/12/2017 - 12:43
ok, but what exactly are you trying to figure out?
User
12/12/2017 - 12:43
if there is any document available online for help?
Excelchat Expert
12/12/2017 - 12:44
apologies but we do not have an online courses for those scenario
Excelchat Expert
12/12/2017 - 12:45
if you can share what you are trying to program then we can find a way to help you out
User
12/12/2017 - 12:45
ok. thank you for your help.
Excelchat Expert
12/12/2017 - 12:45
I need more details to help you out
Excelchat Expert
12/12/2017 - 12:46
are you still with me?
User
12/12/2017 - 12:46
can I get your name?
User
12/12/2017 - 12:46
yes.
Excelchat Expert
12/12/2017 - 12:46
ok good
Excelchat Expert
12/12/2017 - 12:47
what I need to know is the specific program you would like to accomplish so we can start from there
User
12/12/2017 - 12:50
i have a database which I'm trying to amend in order to add more assets onto the database. this requires knowledge on the codes etc. I'm new to this so have no idea where to begin from.
User
12/12/2017 - 12:53
thanks for your help though
Excelchat Expert
12/12/2017 - 12:53
apologies
User
12/12/2017 - 12:53
i found a link.
http://www.excel-easy.com/vba/create-a-macro.html
User
12/12/2017 - 12:53
this should help
User
12/12/2017 - 12:53
no problems
Excelchat Expert
12/12/2017 - 12:54
okay, I really want to help but for me to figure out the codes I should look into the files and should know the exact command that we will program to the developer \
Excelchat Expert
12/12/2017 - 12:54
I hope you will get what you needed from the link though
Excelchat Expert
12/12/2017 - 12:55
In case you have clarification just let me know
User
12/12/2017 - 12:56
i will..thanks
Excelchat Expert
12/12/2017 - 12:56
alright
Excelchat Expert
12/12/2017 - 01:07
are you still with me?
Excelchat Expert
12/12/2017 - 01:11
Do you still need me to stay with you?
Excelchat Expert
12/12/2017 - 01:26
Since I haven't heard from you for a while so I am now ending this session, thank you for you time and for choosing Got it pro, hope to talk to you again.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.