As you may have noticed: the program itself chooses breakfast/ lunch, etc. depending of the time the userform is opened. It's all aimed at reducing the user's task/burden.
To me it seemed unlikely the userform would be opened at 8 AM to enter the data for dinner or even for evening.
You are tsting now for unlikely events (what the userform isn't meant for).
Anyway I adapted the userform for improbable events.
Last edited by snb; 12-21-2020 at 07:47 AM.
Paul
That is great. The default sheet is also very handy. They do change. That was going to be one of my questions before how to adjust for changes.
Everything seems perfect. Can we get that to log?
The cpu is normal with the latest one also.
snb
Looks great. One question is the values do change at times when the dr says to. Also the target for evening 1 and 2 is 150. How do I change the values for target, ratio and factor when needed?
snb
She sometimes has strange schedules. We are still working on getting her sleep schedule better. I think it is very cool to chose by the time of day "I did not notice that" but there are times where her lunch is at 5pm.
So allowing for improbable events is very helpful.
You help is very much appreciated.
So I see you did end up having the CPU usage do the same.
I did some research but unable to find a reason why this could be.
Originally Posted by Paul_Hossler
Yes, it is strange
Attachment 27602
With row 2 solid back, CPU usage is very high
Attachment 27603
Just deleting that row, then CPU usage is normal
There's no formulas or anything else in that row, so it's very^3 strange
Going out on a limb here, but I think I can see what causes the high CPU usage, but not why it does it
The way I set Freeze Pane originally (don't remember how) some how caused the usage to be very high with the rows hidden
Removing the Freeze Pane and making D3 the new Freeze Pane, seems to solve that -- very weird
Capture.JPG
I'm guessing that setting the Freeze Pane to a hidden might be the issue
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Working on it
How do you want the Log sheet sorted?
a. Add at bottom so newest is always in Last Row
b. Insert at top so newest is always in Row 2, next newest is in row 3, etc.
Play with this version
It logs inputs, and writes to next line in log unless you're updating an existing entry, then it just replaces the old data
Last edited by Paul_Hossler; 12-21-2020 at 09:59 PM.
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Paul
i deleted row 2. I then inserted a new row turned it black and locked it. That also solved the issue. I don’t know as much as you. Like what a “freeze pane is “I will look it up” or why that is better to use. But I did find a very easy way to make the cpu usage go away.
I will test that out tomorrow once I get back on my computer. From you explanation it seems to be all I need. I just need the log to look through the history. Just adding to a list is fine. So any features are just a bonus but not needed.
Thanks
In Range("J1:N6") you can adapt any value (as long as you do not change the structure).
Just a way to keep (for ex) row 1 or col 1 or both always on the screen. Can be any row and/or column, but this is typicalLike what a “freeze pane is “I will look it up” or why that is better to use
1. Selecting B2 and Freeze Panes
Picture1.jpg
2. sort of 'locks' row 1 and column A on the screen. This way you can always see the header row(s) and maybe the 'main' column(s)
Capture.JPG
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Posting Permissions
Reply With Quote
