MsgBox or like it for with requiring user input

[Nils Titley]

I am going to be processing some large files and I would like to dispaly what
file I am process but I don't want the user to have to click on a button. I
would like the box to display all the time. Is that possible to do? Where
do I start?

Thanks

 

[Dave Peterson]

You could use a userform.

But even simpler is to use the statusbar--Where you see Ready, Edit, Point in
the bottom left corner.

application.statusbar = now & " Processing: " & somevariablenamehere

at the end of your code, you can reset the statusbar with:

Application.statusbar = false

 

[Nils Titley]

Dave

Thanks I will try that. I just want some thing that will give them a warm
and fuzzy.

 

[Nils Titley]

Dave,

I like it but you also have to have

Application.DisplayStatusBar = True

Thanks

 

[Dave Peterson]

I always have that turned on, so I don't need to turn it on in code <vbg>.

 

[Nils Titley]

Dave,

Yea, you probably been developing VB application for a long time. I am just
developing some thing for a friend and I am learning some thing but I am lost.

I have another question..... can you give me an example of how I move to the
last row. I know how to get the last row value but I don't know how to make
that the starting point where I want to write the new set of data in the
workbook.

I have got the code to the point that I can read, I believe, multiple files
and it is process the data correctly. I believe what is happening now is
that when I write to the result workbook the data is over writing what I have.

I would appreciate your help.

Simple example.

Thanks

 

[Dave Peterson]

If I know the data, I can usually pick out a column that is always filled if
that row is used.

Then I use this kind of code:

Dim NextRow as long
with worksheets("sheet1")
NextRow = .cells(.rows.count,"Z").end(xlup).row + 1

.cells(nextrow,1).value = "This would be in column A"
.cells(nextrow,2).value = "This would be in column B"
.cells(nextrow,3).value = "This would be in column C"
End With

Change Z to the column you can pick out.

Dave,

Yea, you probably been developing VB application for a long time. I am just
developing some thing for a friend and I am learning some thing but I am lost.

I have another question..... can you give me an example of how I move to the
last row. I know how to get the last row value but I don't know how to make
that the starting point where I want to write the new set of data in the
workbook.

I have got the code to the point that I can read, I believe, multiple files
and it is process the data correctly. I believe what is happening now is
that when I write to the result workbook the data is over writing what I have.

I would appreciate your help.

Simple example.

Thanks