Search:

Type: Posts; User: SamDsouza; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    150

    Re: TextBox value as Formula Overwrites

    Thanks NimishK you made me move on.

    Yes i had to modify TxtValues_Afterupdate event to suit the desired results but still not upto the mark.
    Because as per your coding there is miss out on...
  2. Replies
    2
    Views
    150

    TextBox value as Formula Overwrites

    Hello

    The below code somehow overwrites the formula typed in rangeE1
    What i am trying to do is that if i check value as formula then the txtValue should display the Formula if unchecked then it...
  3. Re: Tried the following formula with Absolute referencein VBA but get Application Defined Error

    NimishK and Fluff Thank you so much for the perfect syntax coding

    By the way Macro Recording Steps were slightly difficult to digest. ;)

    Thanks Anyways

    SamD
  4. Tried the following formula with Absolute referencein VBA but get Application Defined Error

    Hello
    I put the following formula in cell CE3


    how to replica in VBA. as i get Appln. Defined Error


    with Ws
    .Range("CE3").Formula = "=if(" & "BE3<(R[-2]C[-82]" & "," & "BF3" & "," & "0" &...
  5. Replies
    12
    Views
    361

    Re: Numberformat with many columns at one go

    Yes Rick removed ".00" . Yes As desired i got. Thankx a tonne :)
  6. Replies
    12
    Views
    361

    Re: Numberformat with many columns at one go

    Thanks Rick. Really Appreciate your timely response. My query for Rounding off was to Post #5 by PGC01
  7. Replies
    12
    Views
    361

    Re: Numberformat with many columns at one go

    Thanks Rick the same format i;ve adopted from .
    http://www.excelfox.com/forum/showthread.php/375-Excel-Number-Format-Indian-Style-Comma-Separation

    in post #1 of this thread. Really Good One...
  8. Replies
    12
    Views
    361

    Re: Numberformat with many columns at one go

    Sorry But how will Union help ?
  9. Replies
    12
    Views
    361

    Re: Numberformat with many columns at one go

    Pgc01

    Thanks i tried it works beautifully. :)
    But what i desire is when any numeric value typed in cols A, E and G want to round off to nearest value
    as per your solution i typed in col A ...
  10. Replies
    12
    Views
    361

    Re: Numberformat with many columns at one go

    pgc01

    Sorry for very late reply.
    do you mean something like this



    dim nos as Integer
    if nos < 1000
    ws.Columns(3, 5, 9, 11, 23, 27).NumberFormat =...
  11. Replies
    12
    Views
    361

    Numberformat with many columns at one go

    Hello

    I want to numberformat with many columns at one go

    Can i



    ws.Columns(3, 5, 9, 11, 23, 27).NumberFormat = Trim(Replace(Format(String(Len(Int(Cell.value)) - 1, "#"), "...
  12. Re: Entering wrong date ie 30-2-19 (30-Feb-2019) in txtDate.text it displays as 19-Feb-1930 instead of showing error msg

    Thank you guys for your wonderful help and suggestions.

    SamD
  13. Re: Entering wrong date ie 30-2-19 (30-Feb-2019) in txtDate.text it displays as 19-Feb-1930 instead of showing error msg

    welshgasman


    Thanks for your reply. I am not a champion as you guys. Still learning VBA for excel from the champion members here.
    if you have dedicated function to share to set the correct date...
  14. Re: Entering wrong date ie 30-2-19 (30-Feb-2019) in txtDate.text it displays as 19-Feb-1930 instead of showing error msg

    Steve the Fish

    Yes, Agreed definately you cant answer for me. Your point is worth considering 2 digit or 4 diigt.
    As users we tend to type 2 digit for Speed up. Well considering now will be 2000...
  15. Re: Entering wrong date ie 30-2-19 (30-Feb-2019) in txtDate.text it displays as 19-Feb-1930 instead of showing error msg

    Thanks NimishK. Tried yours but then i've to put Two digit Nos for Day and Month and Four Digit for year. I think 4 digit for year is good idea rather than 2 digit year.
    Also the same suggestion...
  16. Re: Entering wrong date ie 30-2-19 (30-Feb-2019) in txtDate.text it displays as 19-Feb-1930 instead of showing error msg

    Thanks DanteAmor for your suggestion for adding another validation. Whats happening is i ve to compulsory add 10 digits
    What is desired is Entering dates with the flexibility
    as
    1. 25-01-01 ...
  17. Entering wrong date ie 30-2-19 (30-Feb-2019) in txtDate.text it displays as 19-Feb-1930 instead of showing error msg

    Hello

    Have an issue. when entering wrong date ie 30-2-19 (30-Feb-2019) in txtDate.text it displays as 19-Feb-1930. i dont know why.
    Infact the below code has the msg of Invalid Date. but it by...
  18. Re: Decent Output for Date required as Blank cell which is Empty also in TextBox instead of 30-Dec-1899

    Everything remains the same coding. for posting new thread i will have to repeat the same. if you still insist then will post a new thread
  19. Re: Decent Output for Date required as Blank cell which is Empty also in TextBox instead of 30-Dec-1899

    Yes, Got it Thanks for clarifying.

    ok now when i enter wrong date ie 30-2-19 in txtDate.text it displays as 19-Feb-1930 instead of showing error msg
  20. Re: Decent Output for Date required as Blank cell which is Empty also in TextBox instead of 30-Dec-1899

    repeating the same as per post #7 but with RED


    Private Sub UserForm_Initialize()
    Load UserForm1
    UserForm1.Show vbModeless
    With txtDate.Value = Format(Worksheets("Sheet1").Range("A2").Value,...
  21. Re: Decent Output for Date required as Blank cell which is Empty also in TextBox instead of 30-Dec-1899

    As the above was not clear i did as per your suggestion and implemented in UF intialize. So where was your code supposed to be placed
  22. Re: Decent Output for Date required as Blank cell which is Empty also in TextBox instead of 30-Dec-1899

    Code remains Same as per post #1
    txtDate.Text is very much on userform1
    As per your suggestion changed it see below


    Private Sub UserForm_Initialize()
    Load UserForm1
    UserForm1.Show...
  23. Re: Decent Output for Date required as Blank cell which is Empty also in TextBox instead of 30-Dec-1899

    Changed it. still same error
  24. Re: Decent Output for Date required as Blank cell which is Empty also in TextBox instead of 30-Dec-1899

    Fluff tried


    Private Sub UserForm_Initialize()
    Load UserForm1
    UserForm1.Show vbModeless
    With txtDate.Value = Format(CDate(Worksheets("Sheet1").Range("A2").Value), "dd-mmm-yyyy")
    If...
  25. Decent Output for Date required as Blank cell which is Empty also in TextBox instead of 30-Dec-1899

    Hello
    I've already formatted column 4 with date format as shown below.
    Have also explored that if Date is Blank then the value of that cell of 0 date is 30-Dec-1899. Anyways that i can prevent...
Results 1 to 25 of 60
Page 1 of 3 1 2 3