Search results for query: *

Hello combo. This is resolved. I'm now resetting the Height, Width, Left, and Top properties after the "Zoom can be undefined" code you posted above. The link did not help, but you did get me thinking along the lines of just resetting all the control properties. Thanks

Hello combo, No, there is no code behind any buttons that changes zoom, position or size of controls.

Thank you combo. This code puts me much closer. Is there away to keep the controls from changing size and position? When the code run (on a lower resolution PC) the range I want is visible and the controls look fine. When I click a control (button) it gets very large and so does the font.

Hello All, how can I re-size a worksheet and it's ActiveX buttons based on a user's PC resolution? Is there a way to reliably detect the screen resolution and adjust the worksheet with the ActiveX controls? I have developed a worksheet with ActiveX controls in resolution 1600 x 900. When a...

Hello All, I had a Hommer moment over the weekend. It occur to me that instead of recreating the email wheel, to get images, rich text, attachments, etc. sent in the feedback process I should simply use what's there. So I have VBA some code that calls/opens the email software, populates the...

Thank you SkipVought for replying. I understand what you are saying. Maybe I need a control the holds text and graphics. I have created a feedback function, via a form and email. I want the users to have the ability to past a snapshot into the email's text box an click send. I don't want...

Hello all, I have a text box on a ActiveX form. I have an image on my clipboard. The image can be bitmap, jgp, gif, etc. Is it possible to past that image into the text box? What would I need to code for this to work? Thanks in advance for any help.

Hello combo. This does work. I see what I was doing wrong. This is resolved. Thank you.

Thank you combo. This works. Issue resolved.

Hello combo, Thank you for the post. This only gets me part way there. The user can still scroll right. Any other suggestions would be greatly appreciated.

Hello all, I have an ActiveX toggle button on a worksheet How can I pull the Value ("True" or "False") from the Toggle in a module using Excel VBA? Thanks in advance for any help.

Hello All, I have a worksheet that has hyperlinks in some of the cells. I am using a macro to prevent scrolling on this worksheet. When I prevent the scrolling, via Developer tab ===> Properties ===> ScrollArea A1:Y1 the hyperlink are not clickable. Is there a way to prevent a sheet from...

Thank you both. your suggestions worked just fine. This is resolved.

Hello All, How can I dynamically create EXECL tabs from a list of names in a master tab from a macro? I have a master tab with personal data. In that tab there is a column that has a list of names that repeat - I need to get a distinct list of names from that column - I need to take that list...

Hello all, I have a single source file that I want to split into multiple target files. The source file will vary and contain the target path and file names. See below for details. I want to create generic process that will not rely on hardcoded target path and file names. Is this possible...

Hello everyone. I am brand new to UNIX and need write a script that will run every ten mins. The script will look at a directory full of files that have been FTPed to it. The logic will be: 1) Look at a directory for new files that have an extension of ".send" 2) If there are new ".send"...

Hello All. Does anyone know of a Java code analyzer that will produce/export a data dictionary or glossary? Thanks in advance for any help

Thanks tedsmith. When you say "line statement" you are talking about the VB Line object. True? Also, I have never worked with line statement. Do you have a small snipped of code I could look at? Also, as I scroll either datagrid will I need to reset the coordinates? or will VB resets the...

strongm/gmmastros, Thanks so much. I looked at all three and this is what I'm looking for.

Andrzejek, I don't disagree with your approach long term. But I need to clean up the 100,000+, as they are used downstream in a pivot table. That pivot's summary is skewed because of the name errors. If I can perform the cleanup in an automated way it would save me a lot of manual clean-up...