dcsimg

Search:

Type: Posts; User: sachinns

Search: Search took 0.00 seconds.

  1. VBA Help : Small Automation using VBA Macros

    Hi Friends,


    key Qty Related Products Related Cost Invoiced at
    A -1 CAR 100$ Jan
    B -1 CAR 150$ Jan
    C 0 CAR ...
  2. Re: Excel VBA : Help me to join string and variable using VBA

    @Siddharth Rout

    It can be anything what user gives.
  3. Re: Excel VBA : Help me to join string and variable using VBA

    @westconn1



    Dim MyFormula As String
    MyFormula = TextBox3
    Cells(Lastrow, 3).Formula = "(IF(O9=" + MyFormula + " ,"""");""Missing Leader Price"")"
    '"=IFERROR"
  4. Re: Excel VBA : Help me to join string and variable using VBA

    @jdc2000

    Sorry. Error.
  5. Excel VBA : Help me to join string and variable using VBA

    Hi Friends,

    I have a string and a variable called "Formula". I want to append this string with my variable and update this value in the Cells(Lastrow, 3) of my active sheet.

    String is :
    ...
  6. Re: VBA UserForm : Two Textbox selection with One Click

    I got the idea. Thanks



    textbox1.selstart = textbox2.selstart
  7. Re: Populating 2 values based on 1 button click : Excel User form

    @westconn1

    Thanks a Lot. This is what i was looking for. "Selstart"
  8. [RESOLVED] VBA UserForm : Two Textbox selection with One Click

    I have 2 buttons in my form. So when i press on Button1 , value "A" will come in textbox2 & textbox3 and when i press Button2 "B" will come in textbox2 & textbox3.
    User can enter how much ever...
  9. Re: Populating 2 values based on 1 button click : Excel User form

    @westconn1

    The doubt which i asked is not based on this code. Anyways Thanks
    I will start a new thread for that.
  10. Re: Populating 2 values based on 1 button click : Excel User form

    @westconn1

    Thanks a lot for the code. Its working.
    I have one small doubt.
    Suppose i click anywhere in a textbox1. The same position i want in textbox2. Is it possible ??

    Something like :...
  11. Re: Populating 2 values based on 1 button click : Excel User form

    @westconn1

    There is a combobox with dropdown in the form . After selecting the value in dropdown , we can press on the button. So that value is moved to the textbox.
  12. Re: Populating 2 values based on 1 button click : Excel User form

    @westconn1

    Screenshot 1 : Sheet
    https://cdn3.imggmi.com/uploads/2019/7/31/af2cd4947869bee022f064e50d1e12d8-full.jpg

    Screenshot 2 : Form...
  13. [RESOLVED] Populating 2 values based on 1 button click : Excel User form

    Hello Experts,

    I have a VBA User Form consisting of 1 button and 2 textbox. When i press this button , the value of button is coming in the textbox1. Till this part i have completed.


    ...
  14. Re: VBA Userform : Add value to textbox based on Mouse cursor

    WoW. Thanks alot.

    I was using Text1.Text instead of Text1.SelText .
  15. VBA Userform : Add value to textbox based on Mouse cursor

    Hi Friends,

    https://cdn1.imggmi.com/uploads/2019/7/29/c6ceeb4d19aa30ea60757e24edf21675-full.jpg

    This is my Userform. When ever i press the mathematical buttons values will come in the last of...
  16. Re: USER FORM : ListBox population based on another ListBox value selection [VBA]

    @wetconn1 Working fine as usual . Thanks a lot.
  17. [RESOLVED] USER FORM : ListBox population based on another ListBox value selection [VBA]

    Hi,

    User Form :
    https://cdn1.imggmi.com/uploads/2019/6/29/9ddaf1b073d9c270cd65b454da25915c-full.jpg

    Worksheet : ...
  18. Re: Default VBA USERFORM : Combobox Droplist concatenation Help !!

    Awesome !!! Its working Perfectly. Thanks a lot...!!! You saved me !! :)

    One doubt , suppose i want only values till column CL "Gross Price" (Refer Sample sheet) . Then how this code will be.....
  19. Re: Default VBA USERFORM : Combobox Droplist concatenation Help !!

    169549
  20. Re: Default VBA USERFORM : Combobox Droplist concatenation Help !!

    Download : https://filebin.net/hmzl7ezugdqsmpy8

    OR

    http://www.fast-files.com/getfile.aspx?file=202201169547
  21. Re: Default VBA USERFORM : Combobox Droplist concatenation Help !!

    Hi,

    Download the sheet : https://file.io/zLQtFx


    So, Here is the sheet . Dropdown should start from column AM to CN .
    the values should come in dropdown like :
    Compact NSX-NS (complete CB)...
  22. Re: Default VBA USERFORM : Combobox Droplist concatenation Help !!

    My actual data sheet is too complex and big. So i will explain in a simpler way.

    I have some main headings in my column. for example : we will take "mobile Brands".

    My column heading is Apple ,...
  23. Re: Default VBA USERFORM : Combobox Droplist concatenation Help !!

    The new ddp should includes all columns available in “Inconsistency” sheet .
    Considering the name of the columns in row 8 are the same for all Headings, the columns name reported in the dropdown of...
  24. [RESOLVED] Default VBA USERFORM : Combobox Droplist concatenation Help !!

    Hi Friends,

    Example : www.imgur.com/2lAUMdM


    Please see this image as example. I have a combobox called "cmbpivotvalue" in my Userform. I want " A1,A2,A3,A4,B1,B2,B3,B4,C1,C2,C3,C4 " as values...
  25. VBA USERFORM : Search and Find a String and Remove from the Combobox List

    Hi Friends,

    I have a combobox in User form where the data is taking from a sheet called "Inconsistency Order" and the combobox name is cmbSelChartAttr . I have so many values in the droplist. The...
  26. Re: [RESOLVED] Default Excel User form Using VBA : Help on Unique Values.

    Where to add this code ?? My sheet name is "Inconsistency Order" and combobox name is "cmbSelChartAttr" .

    This is the code for my combobox list.

    Function formInitialize(ws As Worksheet)
    Set...
  27. Re: [RESOLVED] Default Excel User form Using VBA : Help on Unique Values.

    Hi,
    I will explain it.

    Suppose we have sheet with some column values. These values are listed in a combobox list. Example : We have values like : ABC , DEF , GHI , ABC - check , DEF , GHI - check...
  28. Re: Default Excel User form Using VBA : Help on Unique Values.

    Thanks a lot. Its working for me...

    Client is asking for one weird condition. Ex: if in ‘Inconsistency order’ sheet there are two columns called “ABC” and “ABC – Check” in the dropdown will be...
  29. Re: Default Excel User form Using VBA : Help on Unique Values.

    Thanks.

    I am very new to VBA, so can you please modify the existing code . In which it will give only unique values in the combobox called "cmbSelChartAttr" .
  30. [RESOLVED] Default Excel User form Using VBA : Help on Unique Values.

    Hi Friends,

    I am stuck with one thing in a User form . I have a dropdown where the data is taking from a sheet. I want only unique values in the droplist. I already have the code , but can someone...
  31. Re: Default Excel User Form using VBA : Help Needed

    Hi ,
    Can you please provide your Email ID so that i can provide you my excel file. Please check and help me on it.
  32. Re: Default Excel User Form using VBA : Help Needed

    Ok Thanks. But not working for me.

    Can you please help me on this one.

    2. I want to add values of a button to a textbox where ever the cursor is there , In my code the values will be added to...
  33. Re: Default Excel User Form using VBA : Help Needed

    sorry to tell. But both the codes are not working. Both are deleting the last word present in the textbox. after finding space its not getting deleted.
  34. Re: Default Excel User Form using VBA : Help Needed

    Thank you for the code. It is working now , but i am getting error in the end. For eg : if it is "my name is sachin" , it will remove the words when ever i press backspace but on the last word "my"...
  35. Re: Default Excel User Form using VBA : Help Needed

    Thank you for the code. It is working now , but i am getting error in the end. For eg : if it is "my name is sachin" , it will remove the words when ever i press backspace but on the last word "my"...
  36. Re: Default Excel User Form using VBA : Help Needed

    Thanks a lot for responding .

    The code which you provided is not working perfectly. If "space" is there then when i press backspace its not getting deleted.
    For eg: If the textbox is "Hello...
  37. Default Excel User Form using VBA : Help Needed

    Hi Folks,

    I am very new to VBA as well as this forums . So i need your support.

    1. Need code for deleting the values in the textbox using keyboard (like using delete/backspace on the keyboard)...
Results 1 to 37 of 37



Featured


Click Here to Expand Forum to Full Width