Recent content by itn04

I am trying to develop a macro that would loop through the cells in a workbook and identify the cells that contain formulas that have been "plugged". By "plugged" I mean the formula contains references to other cells but also contains a hard-coded amount(s). Example formulas: =A5*B7/C8...

Thanks for the info. guys. I've used Casting in C# but I would have never figured out that you could use it in this context. Jeremy.

Man that works really well. Thanks JurkMonkey. I had hard coded the eventhandler on all twelve textboxes: this.tb_one.MouseDown += new MouseEventHandler(this.OnMouseDown); Your way is much easier and cleaner. Both of you guys used ((Control)sender). What is that called? I understand that...

Great idea!! Now the user can be confident about which textbox they are going to effect with the menu item. Thanks for the help Alex. Jeremy

Thanks again for the help Alex. I'm pretty close to figuring it out. There is actually an opening event for a context menu. One of the members of a context menu is SourceControl. So I have captured the control that has initiated the context menu and I can select it before the menu pops up...

I didn't actually disable the Windows context menu. I created my own context menu and assigned it to each of the textbox controls which replaces the Windows menu. You may have solved my problem though. I just went back and removed the custom context menu from one of the textboxes and the...

Thanks for the help Alex. That would definitely do it if I hard code each textbox's mousedown event but there are twelve of them. I was hoping I could write one method and assign it to each of the textbox's mousedown events. this.tb_one.MouseDown += new MouseEventHandler(this.OnMouseDown)...

How can I make a textbox the active control when the user right-clicks over the control? I have a context menu that pops up when the user right-clicks. One of the menu items changes the font in the selected textbox to have a line through it (strikeout). If the user left clicks or tabs to the...

I have an Excel addin that contains a function. When I use the function in a workbook on my machine it works great. But when another user that has the addin installed on their machine opens the workbook the function is linked to the .xla on my machine. I also have a toolbar that is...