Search results for query: *

Keep in mind RoyVidar's post assumes you want to early bind. I like early bind while writing the program, and if I'm the only one using it I usually keep it that way. If I plan on giving the code to someone else to use, I recommend changing to a late bind before distribution Dim rs1 as object...

Are you coding in Access (Module) when you get this error or are you using another program trying to create this variable. It sounds like you do not have your references set ------------------------ Paul D [pimp] pimpin' aint easy

There is a way to turn off the ballon tips http://support.microsoft.com/?kbid=307729 HOW TO: Disable Notification Area Balloon Tips in Windows XP Paul D [pimp] pimpin' aint easy

Here is the closest I could figure that I think is 'relatively' easy. First, copy the following into the 'view code' for the sheet Sub ComboBox_DropButtonClick() Dim LastRow As String LastRow = Range("B" & Rows.Count).End(xlUp).Address ActiveWorkbook.Names.Add Name:="ComboRange"...

Sorry, I don't think you can get the advanced functionality from the flag status column. After further research I have learned that the flag at the end is not your typical flag status but what is called a quick flag right click, arrange by -> custom, other settings... there is a check box for...

Here's a starting point for you. I wrote this for someone else but with some modifications, it should be able to do what you need. Give it a try and post back if you get stuck Private Sub ImportTextFile() Dim myText As String Dim RowNum As Integer Const FName As String =...

Right on - twinkle twinkle Paul D [pimp] pimpin' aint easy

Ron has your answer http://www.rondebruin.nl/print.htm#odd Paul D [pimp] pimpin' aint easy

for some reason, the flag doesn't want to move unless you remove it first (right click, select show fields... then remove flag status. Select ok to make sure the flag symbol dissapears. Go back to the same dialog and add flag status then move up and it should go. Paul D [pimp] pimpin' aint easy

Kenny2003, As you can see, there are numerous ways to apply this macro, either by running the routine or creating a function with it. If you give specifics of why or what your intent is on using a macro to change the text in the cells, we can offer more assistance. Another example not shown is...

in excel 2003, if you select the data pull down menu, it has a fly-out option for list, then create list. this gives the ability to quickly filter a list based on a selected criteria Paul D [pimp] pimpin' aint easy

Check out Chip's site, he has coded how to do this very nicely http://www.cpearson.com/excel/imptext.htm if you want this code always available, just put it in your personal workbook so it is always available. Another option is put the code in any workbook you desire but create a toolbar...

To plot a line, you only need 2 points. Can't you create a start and end point for each equation then plot it in excel? While this is not tested, I would think solver could simultaneously solve for 20 equations to find the intersection. You could set all the x's to adjust till all the y's...

I have seen issues where charts won't zoom properly if no printers are installed on the computer. Not sure if this applies to you. Paul D [pimp] pimpin' aint easy

Have you used data validation? under settings you can link the available data to your list and you can check or uncheck the in-cell dropdown Paul D [pimp] pimpin' aint easy

Public Sub proper() Dim OldString As String Dim NewString As String Dim posA As Integer Dim posB As Integer OldString = ActiveCell.Value posA = InStr(OldString, "(") posB = InStr(OldString, ")") NewString = Left(OldString, posA) & _ Application.proper(Mid(OldString, posA + 1, posB -...

Have you tried Data, List Paul D [pimp] pimpin' aint easy

It looks fixed width Paul D [pimp] pimpin' aint easy

an array function is merely a storage container. So yes, you could read the text file in an array. But the cells in excel could also be used like an array so you could just read the text into excel.

Yes, VBA can do what you want. Not sure what you mean by array, can you elaborate? Paul D [pimp] pimpin' aint easy