Search results

Hi Marc, The excel application is build to connect to a database to fetch data, that is based on static sql queries (quite a few) stored within the excel application. This has increased the size of the file and is difficult to maintain it as well. The plan is to make it more flexible and move...

Hi Marc, Do you mean to use a control text editor instead of a text box? If that is the case then I did not know if such a control exists and how to add it. I have replaced the TextBox D with a Label. Attached the new version of the sample workbook. Regards, Don

Thank you Marc for your reply. I have changed the steps accordingly and also ammended the Save As step to overwrite file if exists. Also attached the excel file. Hope my requirements are clear In this requirement I am displaying the SQL query of a file which I later use it to execute it...

Hello There, I have a requirement to Open (display contents), Save and Save As (save the contents to a file), text files to be working in a Userform. I have attached a sample workbook with the Userform and explanation for your reference. Could you please advice, how this can be developed in...

Thank you Marc for your response. In p45cal solution and a bit tweek, I got it working. Regards, Don

Thank you for your solution

I moved it above the freeze pane, half way through. When I scroll it, it cuts the remaing part of the the Group

Hi Marc, Thank you for your response. I did not understand. Could you please explain? Regards, Don

Hello There, Thank you for your solution, it looks good. I think I can use it for a different requirement. Please find attach the modified sample for your reference. Before the Freeze Pane, is a Label. When the user scroll's up or down with mouse or key board, the Grouped Text Boxes should...

Hello There, I have a grouped shapes which consists of textboxes and pictures. I would like the following: 1. The Grouped Shapes to stay intact while scrolling the screen. I tried enabling the property of Don't move with cells, in vain. Also, came across a YouTube video where this is done...

I found this link, posting it for your reference: https://www.mrexcel.com/forum/excel-questions/740042-get-worksheet-names-closed-workbook-revisited.html#post3637224 If there are any simpler and newer method, please let me know. Thanks & regards, Don

Hello There, I have 2 workbooks, First.xlsm and Second.xlsm. In the Second.xlsm, I would like to populate all the names of the worksheets from First.xlsm (This workbook is closed), into an Array Could you please advice, how can this be achieved? Thank you & regards, Don

Hello There, I have a few shapes & text box on a worksheet, which I would like to have a animation effect. I have attached a sample workbook with explanation for your reference. Appreciate your help. Look forward to hearing from you. Regards, Don

Hello There, I have a workbook, whose functionality is, it should close the workbook without saving anychanges and without any popups to save the workbook: In the Private Sub Workbook_Open, there are certain Call to some Sub's. In all the Sub's related to Workbook_Open, there is the below...

Hi Marc, I am adding some calculations based on the V variable. When I do a loop of the V, for i = 1 to UBound(V), I see the first value is not shown. V = Filter(Sheet1.Evaluate("TRANSPOSE(IF(" & T & "=" & V & "," & G & "))"), False, False) I used the redim and also included option base 1, in...

Thank you Marc :)

Thank you Marc. I guess the method you showed in the change event is easir to follow. I will stick with that. Regards, Don

Thank you Marc I added the following in the change event and it works Const G = "Tbl_Transaction[Sr.]" and G to include in the formula: V = Filter(Sheet1.Evaluate("TRANSPOSE(IF(" & T & "=" & V & "," & G & "))"), False, False) However, I was not able to get the loop using Find Method. Just...

Beautiful code Marc. No words but just thanks a lot. This is something very useful. :awesome: :) Just another thought. When a search is found in function CheckValueExistsInTable, then is it possible to store only the [Sr.] numbers in an array? Regards, Don

Hello There, I have a sub which search a given value in a Table and returns a single row to the worksheet. There might be cases that the given search value in a Table can have multiple rows. I would like a construction that will get the total number of rows found for the given search value in...

Thank you Stevie for your reply. If I find something will post it here. Regards, Don

Hi Stevie, Thank you for your reply. I added the code in both the workbooks (with the file name change). When I open a third workbook from file explorer or from a Inbox email attachment, it does give a message. In a way I cannot open any excel file when my first and second workbook is open...

Hello There, I have two workbooks with VBA code in it. When the First file is opened (by double click the .xlsm file), it opens the 2nd related file as well. Both these files open in the same instance. I would like to know if the below is possible to achieve, and how: 1. The above instance...

Thank you Ninja

Thank you for showing this option of inserting rows in table. I am just following the existing kind of code that was written for Select, Insert, Update and Delete. Your method seems to be good and I would like to apply it all through our VBA application the above 4 operations. Instead, of...