definitions

[Dryver14]

Thanks for the patience over these questions. The answers really are helping me learn.

Could someone please clarify why "Monthly is dim as string when the return is a value? Thanks.



Dim Monthly as string

Monthly = InputBox("Enter your monthly salary:")

 

[Fluff]

If it was declared a a number (eg Long or Double) & the user clicked cancel you'd get a "Type Mismatch Error"

 

[Dryver14]

Thanks Fluff, that bit makes sense I am still a little unsure why the dim string accepts a number though

 

[Dryver14]

I went looking for the answer and found this

[h=2]Strings[/h]

String data is non-numerical, and is used to store characters and words. All strings consist of characters enclosed within double quotation marks. The string data can include numbers and other numerical symbols but will be treated as text. ​

 

[Fluff]

Whilst it treats a numerical string as text, you can still do some mathematical calculations. Try

Sub chk()
Dim a As String
a = InputBox("enter a number")
MsgBox a + 10 & vbLf & a * 10 & vbLf & a + a
End Sub

Whilst the first 2 lines of the msgbox show the calculated result, the last line is a concatenation

 

[Dryver14]

Thanks Fluff,

I really appreciate your input, Up to now all of my excel and vba skills have been project driven so I (sort of) learned what I needed to and moved on.

Now I have started at the beginning and page by page am making my way to the end of the book I am staggered by how little I know LOL