Click here to Skip to main content
13,097,225 members (64,784 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Hi all,

I have an excel file with many different, but very similar, userforms
When i click on a cell in my worksheet a specific userform will open according to the cell text.

I wanted to know if there is a way to add a c# form to excel which will behave as a userform?
Since the visual studio interface is much simpler and a lot more generic then vb...

Posted 4-Mar-13 21:31pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You have some possibilities:
1) Actually Excel (and practically all Office application) support Add-ins. Thus you could make a legacy excel add-in. There are several tutorials out there, but this is not the simplest one.
2) An other interesting approach:[^]
3) You can call managed code from excel vba, but it is not the wisest one, since vba runs in a rather undeterministic way. Start here:[^]
4) Interop Forms Toolkit[^] might be also an alternative to consider.
nirnirle 7-Mar-13 4:20am
Thanks for your answer.
All of your suggestion seems reasonable, I will have to examine them more thoroughly.
Zoltán Zörgő 7-Mar-13 4:51am
You are welcome.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.170813.1 | Last Updated 5 Mar 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100