Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote -6 down vote favorite

I have written VBA code for excel and it is working fine (MACRO). Now I want to create UI file for excel . Can anyone tell me how to create UI file?

Thanks in Advance.

share|improve this question
 
would help if you showed us your code... –  Philip May 31 at 9:50

1 Answer

up vote 5 down vote

In a few easy steps:
hit ALT+F11 to open VBE (Visual Basic Editor)

right click the VBA Project in the Project Explorer CTRL + R
then follow the below photos

step 1
step2
enter image description here
- Follow this tutorial to add controls and logic to your UserForm

First steps with User Forms

Also, from Philip
here is some more free Excel VBA training for you: Ozgrid Excel MVP and all round VBA Chief: Excel VBA Training

Update!

This is how to create a userform with a (2) two column listbox. It shows how to add values to the listbox at runtime and copy them to spreadsheet.

share|improve this answer
 
+1 nice answer :) –  Philip May 31 at 9:53
1  
@um: here is some more free Excel VBA training for you: Ozgrid Excel MVP and all round VBA Chief: Excel VBA Training –  Philip May 31 at 9:56
 
+1, good work for quite poor question. –  KazJaw May 31 at 21:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.