Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup in userform without erasing formula everytime
I have a userform that transfers data to three worksheets. The first
worksheet looks like the userform, but contains information I would like to print and insert in applicant file, the second worksheet is a summary of all applicants data, and the third worksheet contains first and last name of applicant but need to to provide more data later. Problem is that the userform works, except that it erases the lookup formula after unloading the userform. I think this is because of the control source property. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO I GET LOOKUP TO USE THE SAME RANGE EVERYTIME | Excel Worksheet Functions | |||
Erasing contents and leaving the formula | New Users to Excel | |||
Erasing a Formula? | Excel Discussion (Misc queries) | |||
how do I replace #n/a in a formula with 0, without erasing my for. | Excel Discussion (Misc queries) | |||
How do I make the 0 hidden with erasing the formula in a block? | Excel Discussion (Misc queries) |