Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Input information on K column using userform.

Posted on 2016-10-18
15
46 Views
Last Modified: 2016-10-18
Good afternoon Experts Exchange community and users wanted to see if it is possible to have this userform to work in this way. Thanks for your time and help.

1. Input information using userform
      a. Click on the row that you want to input information.
      b. On the given # put in number
      c. Choose the color that the number will be displaying on.
       d. Click on Enable so that it may be active.
      e. Have information generated/input once you click close button.

Pictures and file will be provided on this question.  Please feel free to ask any question to clear out any inconvenience.

userform-on-k-column-results.png
userform-on-k-column-results-2.png28975135.xlsm
0
Comment
Question by:Omar Hernandez
  • 8
  • 7
15 Comments
 
LVL 46

Expert Comment

by:Martin Liss
ID: 41848851
The picture you show, while similar, is not what I see when I open the "Order" form named NumberArrange.

I also what to say that while it is of course your workbook, IMO you have way too many colors going on.
0
 

Author Comment

by:Omar Hernandez
ID: 41848863
I apologize, Forgot to updated. Here you go Martin and thanks for your fast response. Reason that it has four different colors is to meet a conclusive end goal.
28975135.xlsm
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 41848914
I was talking about the colors on the GENERAL sheet where you have at least 9 colors.

What should happen when CommandButton13 (ENABLE) is clicked?
What should happen when CommandButton14 (DISABLED) is clicked?
When you say "Have information generated/input once you click close button", what information do you want to show up in column K?
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Author Comment

by:Omar Hernandez
ID: 41848933
What should happen when CommandButton13 (ENABLE) is clicked?
---on the row selected column "K", Show the number i have input on the userform (located on letter B)

What should happen when CommandButton14 (DISABLED) is clicked?
---on the row selected column "K", Don't show the number input on the userform (located on letter B)

When you say "Have information generated/input once you click close button", what information do you want to show up in column K?
--- Yes remember that when i also click on the close button other information will be generated/input, will love to have the previous function work in addition with this new information that will be generated/updated as well.
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 41848940
When ENABLE is clicked do you want to immediately see the number appear in column K?
0
 

Author Comment

by:Omar Hernandez
ID: 41848947
I would prefer to have it when i click on the "CLOSE" button. with also having previous updated information when updated working in conjunction with the new information to update.

But, would not mind if it is easier for you doing it the way you have mentioned.
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 41848964
I'll do it when the CLOSE button is clicked.

I'm sorry for all these questions but if the user wants to see the number does he have to click ENABLE before clicking CLOSE? And what happens if he clicks DISABLED before clicking CLOSE? Am I right in assuming that in that case you don't want the number to appear but you do want the rest of the existing code to run? If so wouldn't it be simpler to eliminate the ENABLED and DISABLED buttons and instead just put the "Given #" in column K if it's non-blank?

Anther question is how does column K become something like the "7  !  13"  in cell A29?
0
 

Author Comment

by:Omar Hernandez
ID: 41848998
Hey Martin Liss no problem at all, better have question so that you may understand it with ease and clearness as much as possible.

If the user wants to see the number does he have to click ENABLE before clicking CLOSE?
---Yes, if it is possible to have the option click to be highlighted will appreciated. so that the option picked will be shown.

what happens if you click DISABLED before clicking CLOSE?
---If i click on the DISABLED button before clicking CLOSE, what ever information that is in the userform it will not be shown on the selected row, column "K".

Am I right in assuming that you don't want the number to appear but you do want the rest of the existing code to run?
---Yes, if the recurrence box is disabled, have previous information that when button close is clicked generated. and if it is Enabled have Recurrence box information work in conjunction with previous updated information that generates only when close is clicked.

If so wouldn't it be simpler to eliminate the ENABLED and DISABLED buttons and instead just put the "Given #" in column K if it's non-blank?
--- Yes, but reason i have it vision this way, is because it has other function that will be dealt with with a new question.

Anther question is how does column K become something like the "7  !  13"  in cell A29?
---This also is to be answered in a new question. For more understanding on the userform you have two box where a number is input one is called "Countdown" and "Given #".

Given # = number of days it will have to recurrence let's say this is the " 7  !  7" created on Oct 18

Countdown box = is showing the actual day that has passed. Let's say after i have input the number on the given# being on oct 18, three day has passed and now on the countdown box we will see the following  4 ! 7

Countdown box      Given #

          4               !              7
0
 
LVL 46

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 41849216
Try this.
28977190.xlsm
0
 

Author Comment

by:Omar Hernandez
ID: 41849220
does not show nothing when i

add a number on the given #
choose color
click enable
click close

Is there another way you have it, so that it may display on the file
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 41849221
The ENABLED button is now a toggle so if you click it it will change to DISABLED and nothing will show up. The default state is ENABLED so don't click it.
0
 

Author Comment

by:Omar Hernandez
ID: 41849223
I see, for some reason when trying to make the number display in RED it display in blue.

Beside this it works great.
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 41849228
Change line 3 as shown

Private Sub CommandButton8_Click()
'******* 28977190 Start *******
Set mCB = CommandButton8
'******* 28977190 End *********
End Sub

Open in new window

0
 

Author Closing Comment

by:Omar Hernandez
ID: 41849236
Works great, with a mind like yours visions will be possible. Thanks a mil Martin Liss.
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 41849250
You're welcome.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
Modern/Metro styled message box and input box that directly can replace MsgBox() and InputBox()in Microsoft Access 2013 and later. Also included is a preconfigured error box to be used in error handling.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question