• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. I

    Search for a character/string, get the location's whole word..

    Please ignore my previous post (11), my mistake The code works perfect :):awesome: Thank you @Marc L
  2. I

    Search for a character/string, get the location's whole word..

    Hello @Marc L Thank you for taking the time for the code. Never used Wend, good to know. I executed the code, it displays the second part of the output correct. The first part gets missed out (attached a printscreen) Please advise Regards, Don
  3. I

    Search for a character/string, get the location's whole word..

    If you consider this as an assignment then I will buy you some beer (if it is okay with you) :) I should have solved it by yesterday. But whenever you have time available and can look into it, that would be wonderful :awesome:
  4. I

    Search for a character/string, get the location's whole word..

    Hello p45cal, All I know is, I am seeking your help. I wrote the code and it turned out to be too lengthy & messy one. Discarded it at the end. I am looking forward for a smarter way to get this working and learn too. That is why the post in the forum (with detail description). Regards, Don
  5. I

    Search for a character/string, get the location's whole word..

    Hello @Marc L, @p45cal Thank you for your repsonse. Attached a sample workbook with the explanation for your reference. Regards, Don
  6. I

    Search for a character/string, get the location's whole word..

    Thank you p45cal. The formula would be useful. I will kepp this in mind. For my requirement it has to be in VBA. I will post a sample workbook soon as requestd by Marc Regards, Don
  7. I

    Search for a character/string, get the location's whole word..

    Hello There, I would like to have a VBA Sub which would do the following: Below varaibles: a. l_Paragraph = "A string is any series of characters that are interpreted literally by a script. :x_For example, hello world :x_and LKJH019283 are both examples of strings. In computer...
  8. I

    Reflect comma (,) separated plain text from a variable into a Table

    Super. Thank you @p45cal :)
  9. I

    Reflect comma (,) separated plain text from a variable into a Table

    Wow, this works good. :):awesome::cool: Thank you very much @p45cal for taking the time to make it work. This is very useful and I have learned something good from you. I will study your solution specially the array part. I will try it out with a bigger lText_CSV value. Based on your solution...
  10. I

    Reflect comma (,) separated plain text from a variable into a Table

    Hello @p45cal Thank you for your reply. There is no physical file assigned to lText_CSV. The variable lText_CSV gets the value assigned from a API Webservice response and should be dumped into an Excel Table. This is the reason I included a small sample data assigned to lText_CSV, imitating...
  11. I

    Reflect comma (,) separated plain text from a variable into a Table

    Hello there, I have the below variable which stores a text string (comma separated) from some previous process. This needs to be reflected in a table (to be placed on Table Header Column 2). Please find attached the Sample Workbook.xlsm, which copies the variable string in the clipboard and...
  12. I

    Get PC Device, Windows & Excel Information using Win32 library

    Hello There, I would like to have a VBA Function(s) which would get the below information and return the result as a String. I tried to search on the web and got some but not all the values. My code is quite messier and it takes quite some time to get the results. : Win32_ComputerSystem...
  13. I

    Delete any data/table exists in a given range.

    Hello @vletm Thank you for the DoEvents tip. It did improve the performance I tweaked your code to first check if the cursor is in a table. Then look for special cells, after clearing check if the range is clear then exit for as below. Somehow it is working much better. Thanks again for your...
  14. I

    Delete any data/table exists in a given range.

    Hello @vletm Your solution worked so far very good (below mentioned with a slight modification) Recently, there came quite a large range. The Excel file was freezing (Not Responding). I searched a lot for the possible options and added some lines of code, still the freezing issue remained...
  15. I

    Loop through table columns and set the entire column format based on a condition

    Wonderful! Thank you it works good Regards, Don
  16. I

    Loop through table columns and set the entire column format based on a condition

    Thank you for the sample code. My excuses. Please find attached sample workbook (Sheet2) for your reference. Somehow the control did not go into the expected Elseif. Below snapshot of the cell format, and the format via VAB Msgbox. Both look different Based on your code, I added another...
  17. I

    Loop through table columns and set the entire column format based on a condition

    Hello @Marc L I have one last column to convert. I tried to follow your given code but couldn't make it. Therefore the request. 3rd Elseif statement ElseIf IsDate(.Value) And .Value <> .Text Then 'This is for period_names As seen in the below snapshot, the period name column...
  18. I

    Loop through table columns and set the entire column format based on a condition

    Super! Thank you very much @Marc L Regards, Don
  19. I

    Loop through table columns and set the entire column format based on a condition

    Thank you p45Cal for your quick response and help. Powerquery is something new for me, has not yet tried. Just responded if the requirement could be achieved in a more generic way to identify the column if it meets the conversion criteria, and then do the necessary conversion using VBA...
  20. I

    Loop through table columns and set the entire column format based on a condition

    Thank you Marc L for your response and the sample code. It works perfect for the current table that is displayed in the worksheet. However, as mentioned in the sample workbook I would like (to make this more generic) to loop through all the columns in the first row only and identify whether...
  21. I

    Loop through table columns and set the entire column format based on a condition

    Hello There, I have a table with a few columns, and I would like to loop through the first row and all the table columns and check it's values. If a column value satisfies the criteria then set the entire column format to a certain format. There is a small conversion for the column where there...
  22. I

    VBA Code editor display of line numbers

    Hello There, I came across below sample VBA code (attached snapshot). At start of each line code, there is a line/seq number. Can anyone suggest which tool can be used for such display and use of line/sequence numbers? Thank you & regards, Don
  23. I

    Userform.Textbox: Get whole paragraph at cursor position

    Hi @Hui Thank you for your reply. Your last code works perfect. It displays the cursor position's whole paragraph in the Msgbox. I would like the result that is displayed in the MsgBox(ans), gets selected as seen in the attached snapshot. There is no formatting involved. I did the...
  24. I

    Userform.Textbox: Get whole paragraph at cursor position

    Hello @Hui I am trying to include one last functionality: to highlight the paragraph. I tried various options but cannot figure it out and therefore the request for correction (last section in the below code) Could you please help me out? Thank you once again and look forward to hearing from...
  25. I

    Userform.Textbox: Get whole paragraph at cursor position

    Thank you @Hui :awesome::). It works perfect. Learned something new (Split function) from you. Regards, Don
Top