Search results for query: *

Or try this one: MakePDF, you must download Ghostscript files for that as well. All is explained at: http://www.lexacorp.com.pg/makepdf.html Good luck! Jonathan

While working on an access database I discovered that it is possible for a dropdown list to contain values returned by a query. I also noticed that this is not possible for a frame with checkboxes, although i need that. Thinking off solutions I thought it might be possible to modify the...

Would it be possible to use something like this, but then for subroutines in combination with (macro)buttons in a form? It would save me a lot of code if I could specify arguments while I define only a button and the assignment with arguments. Thanks in advance! Jonathan

Thanks, I knew that, but I would like to get rid of the parameters... just to save me a lot of extra code

When calling a macro from within another macro is it possible to determine the name of the first from the second macro? When your running macro B from macro A, is it possible to find the name of macro A? Thanks in advance! Jonathan

Is it possible to do something like events like in userforms when pressing a commandbutton? It would save me a lot of extra (double) coding. I would like to use a tag from the button to specify the action taken, as I have a range of buttons whit very similar code I would like to reduce it by...

Hi, I'm looking for an explanation, preferably with a schematic/picture of the Poole-Frenkel effect. I specially like to know what is the difference between the Schottky and the Poole-Frenkel effect. I hope someone can help me with finding something like that... Kind regards, Cactus...

Thanks, just noticed the problem was in the difference between the dutch and the englisch version. I did not convert eveything... The english version uses the following statement: =LINEST(B2:B8,A2:A8^{3,2,1},TRUE,TRUE) The dutch uses: =LIJNSCH(B2:B8;A2:A8^{3;2;1};WAAR;WAAR) I simply forgot...

pmover, Your solution sounded very nice, but so far it's not really working. Maybe you can help me solving the problem. Like you suggested i started with a test using a few simple values (y=x2) like below: _|__A__B___C__D_ 1| x y x x2 2| -3 9 -3 9 3| -2 4 -2 4 4| -1 1 -1 1 5|...

First of all, thank you very much for your quick repsonses... adding more digits was indeed the solution for my problem. Learned something new, because I had no idea you could change the number of digits for a trendline. A special thanks I would like to go out to pmover for his neat solution...

...first cell like this and than copied all the way down... the cell as A1 here changes needly for evey new row so that's not the problem. = -0.0023*A1^x6 + 0.1582*A1^5 - 4.3364*A1^4 + 61.02*A1^3 - 463.93*A1^2 + 1806.9*A1 - 3319.1 The first 1500 samples it looks OK, but than the difference...

I don't exactly know what the problem seems to be.. but sometimes you can get some nice insights by just recording the steps you would like to happen... and then generalize strip the code of the trash you don't need. In my opinion it is possible to add data to the Excel worksheet and afterwards...

Well I don't know if this helps you any further, but I think one of the problems could be that your variables are not (correctly) assigned. This results in problems with your VLOOKUP routine. If I look at the syntaxis by means of the help provided with Excel then you would see the following...

Hello, For the forensic investigation of documents a certain technique is used to make indented writing visible. To improve this process we would like to buil this in to a copier. As you might know the copier consists of a charged ciliner coated with polymers, the photoreceptor, on which the...

...Dim varTemp As Variant Dim varArrTemp As Variant Dim i As Long Dim j As Long Dim z As Long ' Choose the pivot as the first element in the range '** In the following line occurs error 9 ** varPivot = varArray(pIndex, pFirst) '** In the above line occurs error 9 ** i = pFirst j = pLast + 1...

Checking for a '='sign does not work in combination with a .Value instruction because .Value always gives the same result as you see in Excel. The .Formula instruction however does show the fysical input of the cell. So use this in combination with an if or case statement. MsgBox...

I don't think the working of the range object is all clear to you. The ay you use it works for absolute cell reference. For relative cell reference it works a little different. First of all: Range("C458").Select Selection.End(xlDown).Select Range("AG458").Select...

I don't know for sure but all office applications support VBA as add-ins maybe Autocad can do that to... If that works you can add the neccesary menu's with some kind of auto_open macro in this add-in. Hope this helps! Jonathan

You can also double click on the edge between two rows or columns, they will then autofit automatically! Select the cell you'd like to wrap text. Right click, choose Format cells (or menu Format and then Cells) and select the sheet [n]Alignment[/b]. Check the check box Wrap text it should...

I think there is a much easier way for the problem you are trying to solve. From the questions you've put here I make up that you try to protect your worksheet depending on the user. Excel has a very good option for that already in it's menu. Under the Tools menu you can protect the worksheet...