Posts by flee01

Re: Evaluate Text As Code

Great answer using application.run. I'll let you know after I test it, but it certainly looks like it is exactly what I need.

I would like to find out how to evaluate text in VBA as code.

Example:

sub myWrapper()
eval("anotherSub oneArg")
end sub

Thanks for any help you can give.

Re: Userform Goes Blank On Loading

There are two types of people in the world, those that can fix problems and those that stand around and look at them. Andy, you are certainly a capable fixer...

Thanks for the help.

Sorry Mike. Andy beat you to it. (P.S. I am not referring to Mike as a person that stands around looking at problems, though I do have someone in mind.)

I have a modal userform that I load to warn the user that the system is busy processing a scheduled job. The form is nothing more than a screen that comes up and says "One moment please..." with the form caption set to "Processing...". When I use the form in this way, if I don't use an application.wait command the form just shows the header without the text that it shows when I look at in the in the VBA IDE. (In other words it is just blank.)

Any ideas other that application.wait. Application.wait is causing other issues as it is known to do.

Re: Dir$() Or Dir() ?

You're always spot on mate. Thanks!!!

What is the difference between these two vba commands?

Re: Increase Data Validation List Item Display

It takes 12 seconds to create a data validation drop down box & I don't have to link it to a cell / range. It fits neatly in a cell too. A combo box on the other hand is more time consuming to setup. I am trying to save time. I just know I would not be satisfied with the combobox solution.

Do you know how to change it in xml? That's what I really need!

Re: Increase Data Validation List Item Display

A combo box just wont help.

Re: Increase Data Validation List Item Display

Are you sure?

bump...When you set validation in a cell for a list of items & you put more than 8 items in the list, excel makes you scroll to find what you are looking for. Is there a way to increase the limit to 10?[hr]*[/hr]

Re: Get Time Excel Was Opened

Well, I have found a way that for now I do not need it. The info provided was very helpfull though.

Re: Open Time

I think that the get file last access time will work for what I need. I have to make sure that it would access excel opening, not a workbook.

Thanks for all the help!

Re: Open Time

Excel itself.

I need to know when excel opened. Is there a way to tell this?

Re: Insert Text At Cursor On Vba Form

I figured it out. See below.

Private Sub timeStamper_Click()
cBoard Format(timeStamp, "m-dd h:mm:ss am/pm")
Application.SendKeys ("^v")
End Sub


Function cBoard(myText)
Set mydata = New DataObject
mydata.SetText myText
mydata.PutInClipboard
End Function

[hr]*[/hr] Auto Merged Post;[dl]*[/dl]Oh yeah. This too.

Function timeStamp()
    Dim serialDate As Long, serialTime As Double
    serialDate = Date
    serialTime = Time
    timeStamp = serialDate + serialTime
End Function

Re: Insert Text At Cursor On Vba Form

I want to insert the time stamp it at whatever is the current cursor position.

I need to insert text at the curson position in a text box on a VBA form. I know how to make the button not take the focus; I just need to know how to pass the cursor a timestamp.

Re: Count Cells Based On Background Color By Formula

Thanks!

I need to be able to count the # of green cells in a range independant of what is in the cell. I can't to do it in VBA. Any sugesstions.

I want to use an excel formula to find the Nth instance of a string in any string. I realize that I could right a UDF for this but find that to be a poor solution. Does anyone have any ideas?