Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cactus13

    Convert doc to pdf using VBA

    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
  2. cactus13

    Manipulating framed checkboxes on Access forms

    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...
  3. cactus13

    Function name as argument to subroutine

    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
  4. cactus13

    Determining the name of a referencing macro?

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

    Determining the name of a referencing macro?

    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
  6. cactus13

    Event on form buttons?

    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...
  7. cactus13

    REQ: Poole-Frenkel

    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...
  8. cactus13

    Trendline problems

    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...
  9. cactus13

    Trendline problems

    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|...
  10. cactus13

    Trendline problems

    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...
  11. cactus13

    Trendline problems

    I have been bashing around with Excel again and have a peculiar situation, in my opinion I'm doing everything right but still Excel makes a difference. Welle here's what I want: I have about 150 files with data. In these files there are about 50000 samples. In this data there are peaks, I want...
  12. cactus13

    Creating a Chart in Excel using VBA

    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...
  13. cactus13

    Urgent VB Macro help!

    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...
  14. cactus13

    Material to transfering electric field to

    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...
  15. cactus13

    Error 9: Subject out of range using QuickSort routine

    Hello, I'm trying to sort a list of data and found the following code (for a Quick Sort routine) on the devx domain (http://www.devx.com/premier/mgznarch/vbpj/2000/04apr00/cs0400/cs0400.asp) but unfortunatley it's not working in my VBA application. Can some one please help me? At the bottom is...
  16. cactus13

    Formula OR value in cell?

    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...
  17. cactus13

    Writing Macro using R1C1 reference...

    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...
  18. cactus13

    VBA program setup disk creation

    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
  19. cactus13

    Wrap Text in Excel2000

    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...
  20. cactus13

    Worksheet Area

    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...

Part and Inventory Search

Back
Top