Automated Vba Macro

Hello to All Forum Members,

I am using Windows 93 and have searched everywhere but cannot find any sample code of how to write a macro that would do any of the following:

1. When opening Excel a commandbutton with no caption must appear.
2. The user then enters a caption on the command button - to indicate to the
command button what the user want the macro to do.

For example:

A. Say the user enters on the Button create "Stock Sheet" - The macro must create the necessary Sheets with complete detail, controls, checks and so on.
B. Create a "Parts List"
C. Production Scheduling Forecast
D. Invoicing, Timesheet, Etc. Etc.

O yes, any WorkBook should have no more or less than 401 Sheets, each with the appropiate tab color, conditional formatting and preset print ranges.

I really thought that Excel was such a fantastic pliable tool with almost no limits, and yet
nobody seems to have this readily available for me to use.

Could anyone of you please be so kind as to write me such a Macro? People I can immediately think of to do it for me would inter alia be, Leith Ross, Daddy Long Legs, SHG, NBVC, Andy Pope and/or anyone else.

I do need it quite urgent please.

Thank you!

Captions Labels etc. all descript naming’s should be set and not easily changed, yes this could be done with VBA code, tricky but doable not that I recommend it unless you can admin the code as required easily

ie if you code as you go and change stuff codes blow up and you sit wondering why

Now it might be useful to have two buttons and change the visible button to the one required and so the code running behind that button is linked to each button (or not, if statement or case will cover this)

Maybe if you had a report to run
Then the button is Green with the text done, V's Red button with report not run
And this could be checked on the close event and open event etc, kinda like using them as user on demand but flags also, bit like second reminder

As for user editing.. Not so sure

Window 93, so not sure version of Excel your running couple be one of a few

jiuk

Sounds perfectly straightforward to me, but I'd recommend avoiding putting strain on the user by making them type in what they want Excel to do. Rather I'd recommend a simple iterative macro which, on every loop, does something random (e.g. inserts a new sheet, or puts in a header, or changes the formatting of a cell, or creates a formula, etc.)

After each iteration simply display a non-modal message asking the user if the sheet looks like they want it to and keep looping until they indicated that yes, it does.

That could barely be 10 minutes work, and I'm surprised that none of the people you mentioned have taken the trouble to write it for you yet.

@Winon - I've made a start for you ... just tweak this to fit your requirements:

Please Login or Register  to view this content.

Hi teylyn,

Andrew-R gave me some code to use but, it does nothing !

I have even tried to tweak his code to something like

Sub DoAnything()

'Ask the user what they want to do and do it
With DoAnything
.Vlookup(Search(Trackdown(Locate OR Find,Andrew-R OR teylyn,excel_forum,www,FALSE)))
If(Vlookup(Search(Trackdown(Locate OR Find,Andrew-R OR teylyn,excel_forum,www,FALSE)))=True Then
Insist on required Macro Assistance
End If
Thank Contributor
End With
End Sub

But it also does not work...

All I really need is a macro to create or write whatever programming is required. I do appreciate and thank Andrew-R for his attemp to help me but, he missed what I am actully asking for. Hopefully, he will have another go at it. Since you seem to be on quite a good footing with Roy, maybe you could consider coaxing him for a more elaborate contribution.

Many Thaks

Have a lovely Day

Originally Posted by teylyn

I think the problem lies with your regional settings. If you need my input you should change your system to German settings. Note, though, that this requires an additional effort for punctuality and correct punctuation.

Surely if you change to the German settings you will need to alter the code thus...

Please Login or Register  to view this content.

You guys ABSOLUTELY ROCK !!!

Thank SOOOO MUCH for your wonderful sense of humour!

OOOPS,

Truly sorry 'bout that royUK, I just got carried away with the unbelievable sense of humor amongst you guys on this excellent Forum.

Hi teylyn,

No you are not being had ! Actually you are quite right. It was in fact Windows 3.1 and 3.11 way back then, and to come and think about it, I must have referred to it as Windows 93, since it was around that time that Windows really started to take the South African market by storm. My very first PC was a 286 with a massive 40MG HDD & an awsome 16Kb RAM - Sounds like DLL's forte since he is hinting that I may approach him to write me my Macro in Sanskrit - LOL

Sorry DDL, I mistakenly quoted your name instead of RomperStomper's

Yes teylyn you are right, and then one also had to back up files on the old big Floppy Disks or use a tape backup - I promise to copy you with romperstompers' Sanskrit code!

Have a lovely day you guys.

I doubt a 286 PC only had 16Kb of RAM, especially one with a 40Mb hard-disk (a decent spec for a 286).

512Kb or 640Kb seems much more likely.

BTW, I think that Windows '93 was one of the development names used for what finally became Windows '95, but I could well be wrong. I was working for P&G when Windows '95 came out and I was the first UK employee to run it (and the 2nd UK employee to have a Pentium class PC - a storming P75).