Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: MouseMove Event : When mouse is outside the edge or border of command button would like to change the background colour of commandbutton

    Excellent :)

    The Perfect one:)

    Thank you so much for your help and explanation. This indeed helped me understand for mousemove Event.
    Thanks once more :beerchug:
    SamD
  2. MouseMove Event : When mouse is outside the edge or border of command button would like to change the background colour of commandbutton

    Hello

    How is above statement in RED justified with below code as i am stuck and color does not change when the mouse is outside the border or edge of command button


    Private Sub...
  3. Re: Why Combobox displays its 1st index value of Duplicate items which are repeated and why not for the duplicate item clicked on

    Yes because of focus moved on second box. Any ideas how this can work smoothly ?

    My question was is there any ComboBox property where up and down buttons were seen when list was more than one...
  4. Re: Why Combobox displays its 1st index value of Duplicate items which are repeated and why not for the duplicate item clicked on

    Jasonb75

    Thanks for your last coding
    with

    ComboBox2.SetFocus
    SendKeys "%{Down}"
    This worked. But is there any ComboBox Property when Comobox2 hilited can still dropdown with option....
  5. Re: Why Combobox displays its 1st index value of Duplicate items which are repeated and why not for the duplicate item clicked on

    You are right.
    if you look below code the Combobox1_Change() event is triggered with .Dropdown ie as when typing each letter The Combobox1 is displayed fully with all options.


    Private Sub...
  6. Re: Why Combobox displays its 1st index value of Duplicate items which are repeated and why not for the duplicate item clicked on

    In Combox1 the Names are items of combobox1. So clicking on ComboBox1 down arrow key the Names are displayed.

    When item or name clicked on ComboBox1 Combobox2 displays the address or Combobox2...
  7. Re: Why Combobox displays its 1st index value of Duplicate items which are repeated and why not for the duplicate item clicked on

    Yongle

    Thanks for this. but now only How to get ComboBox2.dropdown displayed if item Brian Green selected then Combo2 to display 2010 VBA Road: NSW
    or full list displayed of combo2 of items...
  8. Re: Why Combobox displays its 1st index value of Duplicate items which are repeated and why not for the duplicate item clicked on

    Yongle Practical suggestion by you which i had thought of but then structure of the worksheet is disturbed allthough 3 columns at present as per #1

    As per jasonB75 suggestion. Explored and Found...
  9. Re: Why Combobox displays its 1st index value of Duplicate items which are repeated and why not for the duplicate item clicked on

    OK Thanks for the clarification

    It seems no alternative

    Then How do i achieve this ?

    When Brian Green selected will other Combo drop down to display 2010 VBA Road : NSW or go on to 2nd combo...
  10. Re: Why Combobox displays its 1st index value of Duplicate items which are repeated and why not for the duplicate item clicked on

    OMG :-(:sad: Don't tell me.

    Combobox is one of the important tool required for at least list search. Manytimes We are dependant on this very much.

    So are you telling that if items are repeated...
  11. Re: Why Combobox displays its 1st index value of Duplicate items which are repeated and why not for the duplicate item clicked on

    Jasonb75

    Thanks for sharing the links. I've gone through them. Both the threads show to load the items in Combobox when UF initilaized. Only thing two threads dont show the correct index values or...
  12. Why Combobox displays its 1st index value of Duplicate items which are repeated and why not for the duplicate item clicked on

    Hello
    I want to know why Combobox displays its first index value of 1 st item when searched if the items are duplicated repeated. Why cant it display its index value of its respective repeated item...
  13. Re: VBA Excel SQL Error "No Value Given for One or More Required Parameters"

    Thanks Fazza really appreciate your guidance. :). BTW can you suggest website or URL where i can refer to maximum SQL syntaxes.
  14. VBA Excel SQL Error "No Value Given for One or More Required Parameters"

    Hello
    Code adopted from below URL
    https://analystcave.com/excel-using-sql-in-vba-on-excel-data/

    Getting syntax error as per the above heading
    when following query executed

    SELECT...
  15. Replies
    2
    Views
    221

    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...
  16. Replies
    2
    Views
    221

    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...
  17. 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
  18. 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" &...
  19. Replies
    12
    Views
    492

    Re: Numberformat with many columns at one go

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

    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
  21. Replies
    12
    Views
    492

    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...
  22. Replies
    12
    Views
    492

    Re: Numberformat with many columns at one go

    Sorry But how will Union help ?
  23. Replies
    12
    Views
    492

    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 ...
  24. Replies
    12
    Views
    492

    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 =...
  25. Replies
    12
    Views
    492

    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, "#"), "...
Results 1 to 25 of 74
Page 1 of 3 1 2 3