VBA for if statement and increment integer after macro runs to ensure it doesn't repeat

**sintek** · 10-02-2016, 01:58 PM

Hi All

I have the below code that needs a tweak. I need to add a part that allows for a increment that will not allow LKey to be called again after it has been called.So once LKey has been called, Make LKI = 2. My brain is mush right now and can't figure it out.

Please Login or Register  to view this content.

Where and how can I insert the following code to make this work...LKey calls a userform which lets the operator enter a licence key. So once he enters licence key, the code must not ask him aain to do so. I hope this makes sense.

Please Login or Register  to view this content.

**Winon** · 10-02-2016, 02:40 PM

Hello sintek,

Just wondering, what would you like to happen if the procedure/code is called more than once, or twice on the same day?

Should your LKI respond with every instance, or do you want it to remain "as is" after the initial change?

Regards.

**sintek** · 10-02-2016, 02:46 PM

Hi Winon

Thanks for response.... The code must be called once if condition is met, then something must happen so that the code is not called again.
the procedure could be called up to 10 times in a day, so I don't want to have to insert a licence key all the time. Licence key must be inserted once and then something must ensure that it does not need to be inserted again..

LKI must change after initial event so that the condition is not met again

**sintek** · 10-02-2016, 02:56 PM

Perhaps I can explain in more detail without code.

If Day = Today and licence key has been entered then
show a userform
Elseif
Day = Today and licence key has not been entered then
Enter Licence Key
Show Userform
End If

**Winon** · 10-02-2016, 03:06 PM

Thank you for the clarification sintek

,

Where does the license key get entered into?

there are so many other factors at play here, that I (again) would like to ask you to rather attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thank you.

**sintek** · 10-02-2016, 03:26 PM

Thanks Winon

Here you go...

Press [1]
Press [ADMIN]
Enter [1] in first box [2] in second box
Press [Enter]

The licence key has now been activated so when i log in again, I do not want the Licence key UserForm to come up again.

**Winon** · 10-02-2016, 04:15 PM

This is going to take a bit of time, sintek.

A quick fix? No. I'll sort it out for you in the morning.

Good night,

W

**sintek** · 10-02-2016, 04:18 PM

You are a star...sweet dreams..

**Winon** · 10-03-2016, 02:21 AM

Here you go sintek,

The license key is valid for one day only. Each new day will require the License Key to be entered.

It was quite a job with half a Workbook bombing out on me many a time, while trying to make it work, because of other controls and Code removed.

Maybe it would be a good idea to copy me with your Complete Workbook and Code, to make it easier for me with any further help you may require.

Kind Regards.

**sintek** · 10-03-2016, 03:18 AM

Morning Winon

You are seriously a life saver....It works perfectly. I will most definately be able to edit for my purposes. I now know what you meant in an earlier thread that one does not need userforms etc for a POS system.

Have a fantastic day and once again Thanks so much.

**Winon** · 10-03-2016, 03:38 AM

Post duplicated and deleted

**Winon** · 10-03-2016, 03:44 AM

A heartily Good Morning to you as well sintek,

You are welcome, glad I could help a bit, and also thank you for adding to my Reputation. it is Much appreciated.

Mooi dag vir jou ook!

(Hope you understand Afrikaans)

Kind regards.

P.S. Any nice recipe for a nice bun for breakfast?

**sintek** · 10-03-2016, 04:04 AM

Hi Winon

Well deserved I might add. Ja, ek is tweetalig. My culinary skills are limited lol...Can cook, but not a Chef. Always left that to the Kitchen Staff.

Herewith code that works amazingly.

Please Login or Register  to view this content.

**Winon** · 10-03-2016, 04:52 AM

Hi sintek,

Herewith code that works amazingly.

Sorry sintek, I have lost you somewhere along the lines!

Which CommandButton2 where?, I don't seem to be able to apply it to what I have of the trimmed Workbook.

Would you please be so kind as to enlighten me?

Thanks.

**sintek** · 10-03-2016, 05:09 AM

Oops sorry

CommandButton2 Is Admin Button...I changed the variables of the Sheet info manually to test all possible scenarios.

**Winon** · 10-03-2016, 05:23 AM

Wow, you are doing just Great, sintek!

Thank you for the explanation, it was just in time to cancel my appointment with my Shrink.LOL!

Phew, what a relief.

Groete.

**sintek** · 10-03-2016, 08:04 AM

Ha Ha Must say...Without you all and this Forum, I'd be lost.

VBA for if statement and increment integer after macro runs to ensure it doesn't repeat

LinkBack

Thread Tools

Rate This Thread

Display

VBA for if statement and increment integer after macro runs to ensure it doesn't repeat

Re: VBA for if statement and increment integer after macro runs to ensure it doesn't repea

Re: VBA for if statement and increment integer after macro runs to ensure it doesn't repea

Re: VBA for if statement and increment integer after macro runs to ensure it doesn't repea

Re: VBA for if statement and increment integer after macro runs to ensure it doesn't repea

Re: VBA for if statement and increment integer after macro runs to ensure it doesn't repea

Re: VBA for if statement and increment integer after macro runs to ensure it doesn't repea

Re: VBA for if statement and increment integer after macro runs to ensure it doesn't repea

Re: VBA for if statement and increment integer after macro runs to ensure it doesn't repea

Re: VBA for if statement and increment integer after macro runs to ensure it doesn't repea

Re: VBA for if statement and increment integer after macro runs to ensure it doesn't repea

Re: VBA for if statement and increment integer after macro runs to ensure it doesn't repea

Re: VBA for if statement and increment integer after macro runs to ensure it doesn't repea

Re: VBA for if statement and increment integer after macro runs to ensure it doesn't repea

Re: VBA for if statement and increment integer after macro runs to ensure it doesn't repea

Re: VBA for if statement and increment integer after macro runs to ensure it doesn't repea

Re: VBA for if statement and increment integer after macro runs to ensure it doesn't repea

Thread Information

Users Browsing this Thread

Similar Threads

If statement result runs a MACRO

[SOLVED] Ensure running a macro doesn't produce duplicate data

[SOLVED] Event macro runs in wrong workbook/doesn't work properly

[SOLVED] Macro runs perfectly, but dialog box doesn't close automatically

How to ensure the VBA code runs in the current XLS

Script works in Debugger but doesn't when Macro runs

Macro doesn't repeat manual actions

Bookmarks

Bookmarks

Posting Permissions