There's no such thing as a stupid question, but they're the easiest to answer.
Tech Support Guy > >

Keebellah Keebellah is offline  is a Trusted Advisor with special permissions.

Trusted Advisor

Visitor Messages

This form is to write a personal message to another user. DO NOT ASK FOR TECH SUPPORT HERE. To ask your tech support question, please go to the forums or read our welcome guide for new members. Thanks for your cooperation!
Showing Visitor Messages 1 to 10 of 20
  1. BoaterJohn
    27-Oct-2014 08:03 PM
    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
    14-Apr-2014 12:12 PM
    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
    04-Feb-2014 01:21 PM
    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
    19-Dec-2012 07:32 AM
    Hi Keebellah
    Thanks for reply I have posted a file with what I attempt to achieve
    Regards Steve
  5. Teacherless
    02-Jul-2012 10:21 AM
    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
    22-Jun-2012 08:05 AM
    Hi Keebellah,

    Again...thanks for your help!

  7. slurpee55
    10-Apr-2012 10:40 PM
    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
    22-Mar-2012 12:19 AM
    Hi mate need a formula for a an excel sheet...
    If I type firstname lastname in cell A, cell B should auto populate with (ex: satish babu in cell A = 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
    12-Mar-2012 01:24 PM
    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
    01-Mar-2012 08:43 AM
    Hi Kebelah,

    You helped me on a macro find and replace back in december. Now i want to reverse column c to show the sku and not the number id. i have attached a link to the original post below

    please advise


Total Posts
Visitor Messages
General Information
  • Last Activity: 24-Jul-2015 05:02 PM
  • Join Date: 27-Mar-2008
  • Referrals: 1
You Are Using: Server ID
Trusted Website Back to the Top ↑