Where it gets placed.
Here is inline code
Here is regular code
So, might use inline when you want to just paste a single line of command, like to say:
Change line 5 to be Application.ScreenUpdating = False and you should be good.
In Office 2003 or earlier, it 7. Newer versions can go up to 64 functions deep.
However, in your case, it looks like you're just wanting to build a dependent validation list.
This seems like a poorly built table. For instance, what if someone is Full Time, with high salary, but scored a 5? For that matter, there appears to be no way for a Full Time person to get anything besides "Average" or "Poor".
Q2 is much easier, where when given number 1-12, to get the month...
For the basic MsgBox, you can't change the color. If you want to build your own UserForm, then you would be able to customize the color. In your case, it wouldn't be too bad since we're just displaying info. Could be a form with caption and button. You'd need to Load the user form, set value of...
Here's your code.
Dim fCell As Range
Dim firstAdd As String
Dim myCount As Long
'Where are we searching
'What are we looking for?
Set fCell = .Find(what:="T3RRF2", LookIn:=xlValues...
Here's a function you could use.
Function LineSplit(strStart As String, lngLength As Long)
Dim i As Long
'Remove any existing line breaks
strStart = Replace(strStart, Chr(10), "")
For i = lngLength To Len(strStart) Step lngLength + 1
strStart = Left(strStart...
I understand your concern, but my disagreement with it is that Excel doesn't really offer "security", it offers "protection" in these cases. The distinction is that the former refers to keeping files secure, and away from the wrong people. The protection that most people use in XL (sheets...
Since you've already got a filter applied in a way (you're checking for visible cell), then I'd just add another criteria to the filter to hide the cells with 0 and blank. Then it's a simpler copy & paste.