Search results

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...

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...

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...

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

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...

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...

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

Hello @Hui I tried to debug and understand your code and did the following changes to get the paragraph at the cursor position. It does give the results, but not how you it is on the Textbox, the enter/linefeed is missing. I am replacing all the chr(234) with " ". Somewhere with this it is not...

Thank you @vletm. I will adapt your solution. Regards, Don

Hi vletm, Thank you for your response. I suppose to clear contents of that range, and if there exists any table(s) then delete the table(s) as well (Without deleting the actual physical rows or columns) Regards, Don

Hello There, I have a given range (eg. C10:G40) where the data will be pasted. Before I could do that I am checking if that given range is empty/available. If yes then paste the data. If the given range is not empty then I would like to do delete the data: 1.If there are any normal data. 2...

Yes Hui, I will give it a try and see if I can make it work. Regards, Don

Thank you @Hui for the VBA Code. I can use it for a different purpose. The current solution displays the sentence of the cursor location. Whereas it should display the entire paragraph. The identification of a paragraph is a empty line between 2 paragraphs or a sentence. Thanks again and...

Hi Hui, The textbox property is multi line and word wrap = TRUE. The identification criteria in the textbox could be an empty line/line break. I have attached the below example in the updated sample workbook, for your reference. for example: Section Paragraph or Sentence Identification A...

Hello There, Are there any possibilities to have a rich textbox, and how can this be implemented in a Userform? Any sample workbooks would be helpful. Appreciate your response. Regards, Don

Hello There, I would like to know the VBA code to get the entire paragraph at current cursor position in a userform textbox. The solution for my previous post to get the entire word at cursor postion was provided by @Hui. I tried to modify the code inthere, in vain. : Reference below...

Thank you Hui for taking the time in providing the code. It works wonderful!:awesome: Regards, Don

Hi Hui, Thank you for taking the time for providing the code. Please refer the attached snapshot for cases it is giving issues. Look forward to hearing from you. Regards, Don

Hello There, I have a userform with the Textbox. I would like to know the VBA code to get the entire word where the cursor is placed. I have attached a sample workbook for your reference. Thank you & regards, Don

Thank you Hui for the code. Nice to hear from you after a long time. You code does work untill the TextBoxLineNumber display ends. If I enter more lines in the comment (eg. enter line with wordwrap, enter lines beyond the Comments display - Vertical scrollbar seen), the LineNumber does not...

Hello There, In my Userform I have a multiline textbox. The user can load a file content in this textbox as well as they can enter it manually (multi lines). I would like to display line numbers for each line for this textbox. I am not aware, if this could be displayed in the textbox itself...

Hello There, I have a certain chunk of comma seperated values stored in a VBA string variable. In the active worksheet, the user chooses a cell, where it should be pasted. Before it could pasted, I want to make sure there is enough room (rows/columns) for this string value and it does not...

Hi @vletm, Yes, I read your last post. That is why the reply. I don't get paid anything for the work I do. I am sure they would not pay for the 8 hrs fee as well. What I know is, I can buy you a couple of beers. :) But if the change is too much of an effort, then I let it rest. Thank you &...

Hi @vletm Thank you for your reply. The intention was to keep things as is. With the new requirement, the position of the table is changed. With this change then I remembered you and your solution you gave me :) Unfortunately, leaving empty columns/rows before the table is not possible for...

Hello @vletm I have an excel requirement for table row indicator, and I remembered you had provided the solution (wow it has been 2 years) which I am using now. However, I face a minor difficulty. When the table starts from A1, the indicator current row does not work. If I include a blank...