Recent content by cramz

Thanks again stduc

Thanks stduc. I'll post the model number as soon as I get it. In general, however, can XP emulate Win95 for the sake of a printer driver? -C

I'm attempting to configure a printer that only has a driver for windows 95. HP no longer supports the device and hasn't produced a driver for later versions of Windows. I'm looking for options on what I can do. It's a very high-end printer and I'd like to make use of it without setting up a...

Thanks again Fen. I've been toying with VBA a little here and there. This worksheet is actually one in a set that work together to accomplish a common task. -C

Fen: I had a similar idea. I like your outside the box thinking. The only problem is that I'm not going to be the one using it. It's something I'm creating for someone's biz. And I'm locking down much of the spreadsheet's functionality, including changing format. What I was thinking was...

I probably should have specified that some of the text needs to be in color; so telling it to print in only b&w won't solve my issue. I thought there was something that explicitly referenced the non-printing of fill or background colors. Maybe that's access or something else. Any more ideas?

Using Excel 2003. How do I make it so that fill colors do not print?

Thanks for the correction on the nomenclature. And again, thanks for the help, AND the patience. -C

Here it comes...Ohhhh! What you're saying is, don't worry about coming back to the instantiating method. Just go forward. I was trying to come back to the instantiating method. I guess there's no reason why it has to be that way. Okay. Thanks Skip.

This all stems from a double-click event in the worksheet. For a certain case, the creation of a record begins: data is GENERATED, --AND-- this userform pops up to get the rest. The form has 3 buttons: Cancel, Save/Exit, and Save and do more stuff. It's the Save and do more stuff, that requires...

If I Cancel, I DO NOT want the data on the sheet. So I now understand that I should just NOT write the data to the sheet. Simple enough. For the cases that I do want the data, is it possible to put the data from the form into the struct and then pass it back? Or do I continue using the method...

To go one step further, when another button on the form is clicked to save the data, how do I get that information back to the instantiating method?

You are right. Let me step back a sec. In the code above, newEstimate is a data-type/struct I defined. It's nothing fancy at all, just a few strings. To this point, an ID has been generated and date has been stored in newEstimate. The purpose of the form is to get the rest of the data for...

Okay, I know where to find the different events and access the code portion of the userform. Check! What you're saying is that I shouldn't do the processing in the worksheet module, but in the userform code section. My question then becomes, can I pass a user-defined struct to the form? If...

Your suggestions are much appreciated, I'll give that a whirl.