Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox or like it for with requiring user input
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox or like it for with requiring user input
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 wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox or like it for with requiring user input
Dave
Thanks I will try that. I just want some thing that will give them a warm and fuzzy. "Dave Peterson" wrote: 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 wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox or like it for with requiring user input
Dave,
I like it but you also have to have Application.DisplayStatusBar = True Thanks "Dave Peterson" wrote: 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 wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox or like it for with requiring user input
I always have that turned on, so I don't need to turn it on in code <vbg.
Nils Titley wrote: Dave, I like it but you also have to have Application.DisplayStatusBar = True Thanks "Dave Peterson" wrote: 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 wrote: 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 -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox or like it for with requiring user input
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" wrote: I always have that turned on, so I don't need to turn it on in code <vbg. Nils Titley wrote: Dave, I like it but you also have to have Application.DisplayStatusBar = True Thanks "Dave Peterson" wrote: 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 wrote: 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 -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox or like it for with requiring user input
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. Nils Titley wrote: 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" wrote: I always have that turned on, so I don't need to turn it on in code <vbg. Nils Titley wrote: Dave, I like it but you also have to have Application.DisplayStatusBar = True Thanks "Dave Peterson" wrote: 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 wrote: 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 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to hve input box on msgbox | Excel Programming | |||
Fields requiring input | Excel Programming | |||
Displaying a message in a message box without requiring user to click anything to proceed | Excel Programming | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
MsgBox and User Input | Excel Programming |