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

VBA Display Excel table in a pop-up window

D

Delin Mathew

New Member
I am very new to VBA (a week). I need to optimize an application that will update the parts of an assembly in DPE Frame (tool).
The application currently works this way: The user inputs the name of the parts he needs to change into an excel sheet, and the application compares the new part value with the old part value and updates it in the tool. At the end, the application also creates a report using excel with the old value and new value.
What needs to be done: Before the application updates the new value into the tool, I want a window which looks like a table to appear and it should contain the old value in the first column, the new value in the second column, a checkbox in the third column and a text box in the fourth column. This should work as follows: Only if the user checks the Checkbox, should the value be updated in the tool. And in case the user disagrees with both the new and the old value, then he can enter his own value into the text box and now this value in the text box will be updated in the tool.
My Question: How do I create such a window which looks like a table and how do I fill it in with the values, check box and text box? I think I should use excel, but I have no idea how to make it appear as a GUI. Please help.
Thank You.
 
Check photo sample. Could Your 'pop-up' be 'Form'?
How many names need to 'input' for one selection?
If only one, then no need upper like 'table'.
If more ... names could fill to that 'table'.
Anyway, own value should enter out of 'table'.
Ideas?
 

Attachments

  • DeMa.png
    DeMa.png
    20.5 KB · Views: 12
Thanks a lot for your response.

That's almost like what I want in the pop-up window. The only difference is there is more than one input say about 50 old vales and their corresponding new values in every line and also each line will have a checkbox and a textbox associated with it. The old values are pulled from the tool and the new values are pulled from an excel sheet. Can a listbox be used for this?

And this program is for a tool and not for an excel sheet. The code needs to be written in the tool. Any idea how to create such a userform/ listbox using VBScript?
 
You must log in or register to reply here.
Back
Top