Search results

Hello There, Thank you for taking the time to look into my post and helping me out. I have a workbook with 3 worksheets as below: 1. "Customer Header" --> Columns Customer ID, Customer Name & Amount (This contains unique row for each Customer ID and...

Hello There, I have a given excel table "Tbl_Customers" with the below column Names: 1. Customer ID (Unique) 2. Customer Name 3. Amount And 3 Cells (where User can enter), 1 message cell and 2 buttons: 1. Customer ID 2. Customer Name 3. Amount 4. Operation Message: To display a message 5...

Thank you p45cal for taking the time to make it work. Thank you Belleke for the inital solution. Regards, Don

Hello Belleke Could you please guide on my previous post (the changes on your last file updates)? Thank you & regards, Don

Thank you shrivallabha This works perfect.

Hello There, I have the below code which runs a sheel command to open a pdf file. The application does open but the file does not open. If I remove the space from the file name the pdf file opens. Could you please help in providing a generic VBA code to open a file. Which can handle both a...

Hello There, I have a Userform Webbrowser item which displays a pdf file. I would like to know if there is a way using VBA, to copy the entire file content (text) into a worksheet. Could you please assist in providing the VBA code? fyi: One of my previous post where I had asked how to display...

Thank you Belleke, This version is instead adding a new row to the Listbox, where as it should do an update. - if there is a Check In Number in the Listbox --> then it should update it in the Listbox -else it should insert a new row in the Listbox Thanks again and look forward to hearing...

Hi Belleke, Thank you for taking the time to make this work.:):awesome: There is one small change required: -In the Userform, when I change any value and click button 'Send to List' it should do the update only in the Listbox. Whereas now it does update in the table 'Tbl_Checkin' as well, this...

Hello There, After searching through the web, I came across a workaround using Webrowser item to display the pdf file Private Sub UserForm_Initialize() WebBrowser1.Navigate "e:\abc.pdf" End Sub Now, I am looking for how: 1. the entire content displayed in this Webbrowser1 (pdf file)...

Hello There, I have an excel table and I would like to do certain operation using a Userform Listbox. When the Userform is loaded, it should populate the rows into the Listbox. When the Userform is active, certain operations on the Listbox (eg. update, delete, change sequence of row, etc.) are...

Hello There, I am looking to do the following: 1. Create a Userform: -add a Userform ListBox item: where it would populate all pdf files from a given directory -add a Userform PDF display item: Next to the Listbox, display the content of the PDF file 2. On click of a listbox row...

Thank you Logit

Hello there, I have a table with 2 columns as below: -a leading column name "Task" -corresponding column "Value" I would like to know how the actual VBA code can be done which can perform this action: Eg. When I double click on table row 1, column 'Value' cell, it should display a message...

found it, had to scroll down :)

Hi vletm Could you please let me knowhow this is achieved? I am not able to se any code in VBA. Regards, Don

Thank you vletm for your help. Regards, Don

Hi Chihiro, Thank you for the reference link, it is of help. The buttons to trigger the code is only for the purpose of demo and not included in the actual scenario. Could you please assist me in vba code with Case A, to highlight only the first column cell of the current row in table...

Hi Chihiro, These are 2 seperate requirements. The common thing in these, is the visual identification of the cursor location in the table row. I should have created 2 buttons to make it more clearer. Case A: To highlight, only the first cell of the first column, current cursor location of the...

Hello There, I have 2 requirements to indicate current row selection in a table as below and to achieve this using VBA: 1. To highlight the current row's specific column (with fill colour) 2. To highlight the entire row (with fill colour) I have attached a sample workbook for your reference...

The other nice thing is I see in your code, how you can write conditions in one line (eg. the If else condition in one line) :cool: Regards, Don

Thank you Marc for the kid nutritional beginner starter code :cool:. This helps me in growing in VBA. Regards, Don

Hi Marc, My understanding of VBA is very limited. The reason I have joined the group is to learn from people who are experts. To study how their code is written and progress further and also have respect for each other. For your reference: yesterday, managed to put this together from various...

Thank you Marc for the tips. What I am looking for is the actual VBA code of how this can be implemented. I would appreacite your help towards it. Thanks again and look forward to hearing from you. Regards, Don

Hi Marc, The description from point 1 to 4 was the explanation of the process as to the why question, from you. Point 4 is not included in the workbook, this will be worked out by the database people. For me the requiirement is only from 1 to 3 to be working in the VBA userform (as per post 3...