Last Activity:
Oct 6, 2015 at 3:39 PM
Mar 27, 2008
Likes Received:
Trophy Points:
Home Page:
Oegstgeest, The Netherlands
Free lance VBA programmer, Application Engineer


Male, from Oegstgeest, The Netherlands

Trusted Advisor
Keebellah was last seen:
Oct 6, 2015 at 3:39 PM
    1. BoaterJohn
      Thank you for reply,
      when a access form field has focus, if the text field "year" is "2000" for example, then the shortdate DueDate field is to be #05/01/2001". As you can see, the DueDate field is always one year more than the "Year" show field. But the DueDate field show the #error
    2. Ramsez
      Hello Good sir,
      I'd like to know if it is possible to re-open a thread ( You gave me an amazing formula that actually worked and does what it should do, but I'd like to know if it's possible to apply that formula to the whole column. Lets say my column has 3 rows:


      With the formula, right now I am creating a new column, in which I use the formula to transform these numbers into the appropriate format, then I have to copy the whole column and paste only the values in the original column and then delete the column I used for the formula. I'd like to know if it's possible to directly apply this formula on the column itself with some vba. I tried recording my macro, but since the number of rows is different from file to file. I still spend a lot of time doing stuff manually.

      Thanks a lot in advance. :)
    3. vitalspec
      Hello Hans.
      I am desperately looking for answer on something You might know:
      If there is any way via code copy worksheet within workbook without copying sub/macros/code in original worksheet?
      Thanks in advance...
    4. raceform
      Hi Keebellah
      Thanks for reply I have posted a file with what I attempt to achieve
      Regards Steve
    5. Teacherless
      Hi Hans, sorry for delay, just been out to get a new internet modem, my connection is much better now. I think what I will do is send you my complete 2003 wb so that you can see exactly what is what. If you sell it, we go halves on the profit. It is a diamond pricing calculator, really useful to jewelers. As you will see,it has 30 sheets, 24 of which contain data bases and conversion formulas. Before I send it you must tell me if you have the means to open the password protected vba editor. If you haven't then let me know.
      Regards, John
    6. tennisfrk159
      Hi Keebellah,

      Again...thanks for your help!

    7. slurpee55
      Hi! It has been a long time - I have been unemployed since Jan. of 2011 and don't have a new version of Office (I have been using LibreOffice instead, but I don't really like it much.) The lack of a newer version has meant that I haven't been able to assist people on here much. I miss it, but oh well....
    8. satibab
      Hi mate need a formula for a an excel sheet...
      If I type firstname lastname in cell A, cell B should auto populate with [email protected] (ex: satish babu in cell A = [email protected] in cell B).... This formula did not work anyother suggestion (=LEFT(A1,FIND(" ",A1)-1)&"."&SUBSTITUTE(A1,LEFT(A1,FIND(" ",A1)),"")&"@XYZ.COM")
    9. Zack Barresse
      Zack Barresse
      Hello Hans, I just saw your note from January! Sorry I missed it. I like your function. As little overhead as the constants carry, since they are loaded at time of compile, I don't mind just concatenating what I need together, and would use less resources during run time. Why did you not just use the String() function, why the loop?
    10. rweb
    11. vinotech
    12. Ziggy1
    13. vinwin06
      Hi Hans,

      Hope you have a great new year.

      I need your help in one of my older post called Combining 30 text files into single text file. In this thread you have given one VB script file for removing header in the output file. I have clarification that whether i need change any coding that because for running that Vb script file for the month of December i am getting error that "Kmart_1211.txt" does not contain any data. Actually i check file also it having only December month data.

      I think the problem is because of the year. The output file have the data of December 2010 (1210), But if run the VB script now it will consider as 2011, i think this is the confusion.

      Please help me on this.


      Vinoth S
    14. SPeteS
    15. Ziggy1
  • Loading...
  • Loading...
  • About

    Home Page:
    Oegstgeest, The Netherlands
    Free lance VBA programmer, Application Engineer
    First Name:
    Real name: Hans
    Grew up in Central America (Costa Rica) age 1-17
    Studied math in Barcelona and Geology in both Spain and the Netherlands
    Worked for almost 13 years in several African countries for the United Nations Development Programme (UNDP) as a Geologist
    Started using a computer in 1983
    Play a little tennis and volley-ball, ride bicycle
    In IT since 87.
    Officially retired 01.01.2015


    Hans :D
    A macro does what you tell it to do, not what you want it to do.
    It's all in the code... and may the code be with you! If it isn't . . . start debugging!
    •(Time zone: Western Europe)
  • Loading...