Search results for query: *

You beauty SkipVought, that is brilliant[2thumbsup] George

Hi, I want to know if I have a named cell e.g. A1 is Named as "AValue" and holds the number 33.6. So in a formula if I AValue I get the number 33.6 Now if I have A2 holding "AVa" and B2 holds "lue". If C2 has the formula "=concatenate(A2,B2)" the result in C2 is "AValue" as text. Now the...

Hi, Does anyone know of a library package or similar that will allow me to convert and save jpeg images into PGM format using VB6? Thanks George

Hi Vampire and JoeAtWork, Thanks for your suggestions that worked, just me being a little thick, perhaps the days are getting too long. This resource is fanatastic and guys like you certainly make it what it is. George

Hi, I used your code in thread222-1000041 but I get an error on this line COMMData.NewDataString = S in Private Sub MsComm1_OnComm() ' this sub fires whenever new data has arrived at the Comm port Dim S As String S = MSComm1.Input ' send this new string to the COMMData class for assembly...

Hi, Thanks, turns out I found the error. I had created a variable with the same name as a control on my form. George

Hi, Suddenly one of my databases which has forms produces an error when ever I use a control that has an event procedure attached. For example when I have an event procedure On Mouse Down and click on it, I get "The expression On Mouse Down you entered as the event property setting produced...

Hi, I want to insert an image in an Excel workbook so that each time the workbook is opened the image is refreshed so that I get the latest version of the image. I am sure this is easy but today has been long and obviously the mind is mush. Any help most appreciated. Thanks George

Hi, I have a spreadsheet that has many formula and decided it was better to name the cells used in those formulas with meaningful names. Presently they are in $C$R format. So having named the appropriate cells, I now want to change all the formula references from $C$R type to my Names. Is...

Thanks CubeE101, That sorted it. George

Hi, I am trying to develop an application and it seems as though all my projects are linked which causes them to all update each time I save the current project. What I want to do is to make a new version of my project by saving the present project with a new name e.g. if my present project...

Thanks for that clarification, I didn't realise that Require Variable Declaration was important when each module was created. But..., I have been unable to find Option Expilict in any modules in the workbook - that is my problem - there appears to be something else affecting it but for the life...

Hi, I have been given an excel workbook to check the macro coding and each time I run any of the macros I get an error "Compile Error Can't find project or library" on a line such as "ThisRow=2" if I declare the variable with a Dim statement the macro will proceed until the next variable...

Hi Gerry, Thanks for that, a nice little trick. George

Hi, I have a combo box on a Userform (initiated by clicking a command button)that I want to show all the names of the sheets in a workbook - no problem to achieve this - I added the names using AddItem on the Userform Initialise event, then I show the Userform. The inital value shown in the...

Hi Tony, You deserve a star(which I have given you), a very simple answer that works just as I wanted. In my Workbook macro I made my button on that sheet invisible when the workbook was opened. When a user changes any data on the raw data sheet, the event procedure makes the button visible...

Hi Tony, I have used the Control Toolbox to place a Command Button on the sheet. Right Clicking this gives you the option to open the Properties of the command button where the default name for the button of "CommandButton1" can be changed, I changed it to Calculate. You can also embed similar...

Hi, I have an event procedure that is triggered when any data in the sheet is changed, part of this event should unhide (make visible) a command button to re-calculate other information in the workbook. I am having trouble hiding and unhiding the command button. I have used the Control toolbox...

Hi, Using Names for cells, ranges or variables is really useful especially using them in macros but does anyone know if they can be restricted to use on just one sheet, or perhaps some sheets but not others. Generally they are available on all sheets in the workbook. Thanks George George

Hi, I have two excel data files that have a DateTime column in the following format dd/mm/yyyy hh:mm:ss What I want to do is take the first DateTime value in file one and find the closest time in file two and then copy some data from file two to file one. All the copying etc is no problem, my...