I am a VBA novice trying to create a program.
I need some help with a a vba program because I am facing some challenges with reaching the requirement that is need.
Could anyone help me achieve the required output for C24 & D24? Feel free to modify the code if required.
Required outputs are listed in the excel file. Thank you.
Last edited by trippyninjas; 03-09-2020 at 09:09 AM.
I did for the D20: D22 range.
For C20: C22 code lines commented.
Adapt to your needs.
Please Login or Register to view this content.
Last edited by maras_mak; 03-09-2020 at 10:32 AM.
Best Regards,
Maras.
I apologize. I have made a mistake uploading the worksheet with the outdated property value.
Here is the excel sheet with the updated property values.
Could you use this updated worksheet with the updated properties instead?
Thank you!
Last edited by trippyninjas; 03-09-2020 at 08:44 AM.
UDF, use in cell like
C24:
=MinMin(C20:C22)
D24:
=MaxMax(D20:D22)
Please Login or Register to view this content.
Hello everyone. As a VBA novice, I don't really understand a lot of the syntaxes.
Could you upload the worksheet with comment lines? That way i can better undestand the codes better.
Thanks!
What do you not understand?
Do you want to know how to use it? or what each line does?
That is correct. I would like to understand the code better because I need to explain the program as well. Could you use the RangeExe2 file and reupload it here? I appreciate it
Then just point out the line(s) that you don't understand.
I don't know how well you know about VBA, so no idea to "explain", if you do not understand any one line of the code.
Ah you have a good point. I will highlight the lines that I am unable to understand and get back to you.
*One issue* I have pasted your code into the worksheet but it still produces the same result.. instead of 1kHz - 5Mhz for C24, it is still displaying 1kHz-10Mhz.
What should i do?
VBA code should be placed in a Standard code module, not a worksheet code module.
Amazing. it works now. Thank you very much.
I have a similar requirement here but with voltage. Could you help me out please?
Thank you!
Best regards,
Chris
No need of vba
formula;
C24:
=MAX(LEFT(C20:C22,LEN(C20:C22)-3)+0)&"V/m"
Confirm with Ctrl + Shift + Enter (Array formula entry)
The copy to the right.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Hello jindon!
Unfortunately, i require output to display the highest value when 1 or more button is pressed. *Could be A + B or A + C*
Therefore, not every button will be pressed together in every case. The formula you provided works only when all buttons are pressed together.
I'm sorry i did not specify that earlier. :P
What do you mean byNo idea about what you are trying to do.*Could be A + B or A + C*
In the program, there are 3 buttons (Range A, Range B & Range C).
The code only works when all 3 buttons are pressed together.
In a scenario where only button Range A and Range C are pressed together, what should i do to display the highest value in C24 & D24?
Thank you
Still not clear.
What do you want to happen when
1) Range A pressed.
2) Range B pressed
3) Range C pressed
4) Range A + Range B pressed
etc.etc...
The user is free to press any 2 buttons or all 3 at the same time.
Based on which buttons are pressed, column C20 - D22 will display the of the values (from Properties) accordingly.
The program will compare the values inside of C20 - C22 and display the highest value in C24. The same for D24.
Pressing only 1 button is not required because theres nothing for the program to compare. However, what happens if a user presses
(Range A + Range B) as you have stated or (Range A + Range C) etc.. ?
then C24 should be able to compare the values and display the highest value as the requirement suggests.
Last edited by trippyninjas; 03-10-2020 at 05:31 AM.
Then change the formula to
=IF(COUNTA(C20:C22),MAX(IF(C20:C22<>"",LEFT(C20:C22,LEN(C20:C22)-3)+0))&"V/m","")
Confirm with Ctrl + Shift + Enter (array formula entry)
Hello jindon!
Unfortunately i'll have to make some admendments with the requirement. Could you help me amend the modules to meet the requirement? Thank you.
Last edited by trippyninjas; 03-18-2020 at 03:18 AM.
C24
=IF(COUNTA(C20:C22),MinMax(C20:C22),"")
copy to the right.
You are not allowed to create duplicate thread.Please Login or Register to view this content.
https://www.excelforum.com/excel-pro...in-a-cell.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks