By "dialog box" do you mean "userform"?
If so, have you looked at the properties panel for the
"fields" in your userform?
each of them have a property called "value" or "text".
If you set this property to the value of the cell  contents,
then you've just populated your userform.

Usually, you set these in the userform_initialize macro.

I know this is vague, but it's really very intuitive once
you know where to look.

So... let's start with the first question.
Is your "dialog box" a "userform" ??
Or are you using a MsgBox to just display  the results
of the script?
A message box  can be shown as:
TotalHrs = cells(4,3) '(or whatever)
TotalVac = Cells(4,5) '(or whatever)
TotalSick = Cells(4,6)

Msg = "Total Hours worked: " & TotalHrs & chr(13)
Msg = Msg & "Total vacation Time: " & TotalVac & chr(13)
Msg = Msg & "Total Sick Time: " & TotalSick
Msgbox Msg

Of course, there is the possibility that I'm totally misunderstanding the
question.

let me know if I can be more vague... er... specific...