• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. Visor

    Load in userform image created in sheet

    Greetings dear forum members, .. Regarding this issue, I have obtained two solutions kindly provided by jolivanes and Artik in a cross post from another forum that can be reviewed at the following link: Solutions to the issue I hope it can also be of use to you if you are also looking for...
  2. Visor

    Load in userform image created in sheet

    Yes indeed, ... thank you, what you tell me ... I saw that I was not going to have a suggestion or possibility of a solution, I understand that sometimes we are very busy, but I wanted to solve why I had to submit a report with the image ... A thousand apologies and just enter to indicate that I...
  3. Visor

    Load in userform image created in sheet

    Greetings I would like to know if I need to provide more explanation of the subject or perhaps it is not possible to upload the image to userform in this case. I would like to know, because I understand that the image changes its name every time it is generated
  4. Visor

    Load in userform image created in sheet

    Greetings forum members. With a macro a QR image is created, ... I would like to be able to upload it to userform1 I have tried various things, but cannot. How could I achieve this? Thank you in advance for your collaboration
  5. Visor

    Advanced search with several comboboxes

    je... Then better not have invented the userforms:confuso:
  6. Visor

    Advanced search with several comboboxes

    Thank you Chihiro In a userform we can have control of all the sheets. mmm! But, for your answer, .. I suppose that the search or filtering with combobox, can not be done in userform ...
  7. Visor

    Advanced search with several comboboxes

    Thanks for your reply. Actually, I do not know how to apply the vba to search by filtering vba by selecting in combobox what I want to filter. As you will see the CbxAño searches and finds, (only this), ... but you are right is not very flexible. Now, what I filtered would like to see it in the...
  8. Visor

    Advanced search with several comboboxes

    Dear forum friends, I can not find a way to make a search using a single combobox or several comboboxes. Surely you have to use the "and" or "or" operators and show me in the listbox what corresponds based on what is shown in Sheet 2 (Resum) I appreciate your kind collaboration upload the file...
  9. Visor

    Calculate percentage of percentages

    Dear Master Hu, your guidance has led to certain issues and has become the problem in more complexity. But it seems that it is already taking more realistic form. and I thank you for that. Taking into account date of beginning and date and days of delay that is estimated will end date of the...
  10. Visor

    Calculate percentage of percentages

    Thanks Maestri Hui, I think that the values must correspond and be automatic, if I put the 1 in weight the percentage of management increases, for this, .. for E5 to E11, =IF(C5=1;0.1;IF(C5=2;0.4;IF(C5=3;0.6;IF(C5=4;0.8;IF(C5=5;0.9;""))))) although these two actually come to be the same for the...
  11. Visor

    Encrypt and decrypt text with own alphabet from userform.

    That's why I said I got lost, because in G4 I have and, in G6 I have
  12. Visor

    Encrypt and decrypt text with own alphabet from userform.

    I saw that it was a UDF function, so I used it in the worksheet but,.. I got lost, ... Maybe I should use it in a userform ... !! ??
  13. Visor

    Calculate percentage of percentages

    Thank you Master Hui, the average, I had not seen, excellent! It is wrong to try to calculate the percentage of percentages. But in the matter of applying weight, I lost myself there, in the calculations you have made. Anyway, the weight would also put it in a subjective way when I put from 1...
  14. Visor

    Encrypt and decrypt text with own alphabet from userform.

    Hi I do not know what's going on but I do not see how it works The text that is there, copy it from your previous post
  15. Visor

    Calculate percentage of percentages

    Dear forum friends, I would like you to help me, in a formula to calculate the percentage of items that are in percentages. I expect the result to be in cell E4. Take into account that when each cell below E4 is 100% fulfilled, the value of E4 will increase until reaching 100% compliance...
  16. Visor

    Encrypt and decrypt text with own alphabet from userform.

    Great, although it leaves me with no questions because I do not know if it is associated to a pre-established code, or it is generated randomly. If it is one established as ASCII, some good expert will decipher it. That is why he proposed his own alphabet. I would like to do a test: Can you...
  17. Visor

    Encrypt and decrypt text with own alphabet from userform.

    Dear Marc L, The lightness sometimes brings problems! I apologize.. And that happens to me because I do not know how to handle functions from the userforms I have now reviewed that I am on the desktop with my own PC, I have seen that you use functions and this mecrum and decode with...
  18. Visor

    Encrypt and decrypt text with own alphabet from userform.

    Master Hui, this result very goo!! Case Is = Chr(32) newletraMay = newletraMay + "0" to include space. only, is error decrypt gtext when I use LEER button
  19. Visor

    Encrypt and decrypt text with own alphabet from userform.

    Greetings Master Hui, I understood, .. the solution was that I join all the codes of the select case, .. so I did and it turned out very well. What I have left is to incorporate the space bar and insert a zero "0" in the sheet and then use the READ button sorry I was slow to understand
  20. Visor

    Encrypt and decrypt text with own alphabet from userform.

    Dear teacher Hui, yes! Likewise, it's just how I want it to work. But as I see what you have written is "ello handoo" as the capital letter H and C has not come out How is it possible to write Hello Chandoo, capital letters and minuscule? I also can not decipher when I click on the READ...
  21. Visor

    Encrypt and decrypt text with own alphabet from userform.

    Dear friends of the forum, with the aim of generating a userform to encrypt and decrypt text I would like to achieve that what is written in textbox1 can enter in cell B2. Likewise can show in the textbox1 what is contained in cell B2 The macro is made with characters selected in a personal way...
  22. Visor

    Separate letters in columns

    Thanks GCExcel, it works very well, just as I wanted, however I thought that the code that I put sub separar() g = Hoja1.Range("B" & Rows.Count).End(xlUp).Row 'Separar los numeros en cada celda código = Hoja1.Range("BA" & g - 1) For y = 1 To Len(código) Hoja1.Cells(g, y + 3) =...
  23. Visor

    Separate letters in columns

    Thanks for answering, I really just want the letters to be located separating every 4, that is, in the fifth position there will be an empty cell in the direction of the cell with yellow filling. It is a test result sheet for students. Now to exploit the green colors, it really is: number of...
  24. Visor

    Separate letters in columns

    Dear friends, what can I miss to get every 4 cells to skip a cell and continue separating the letters of the contents of a cell? so that it is the same as shown in row 10 from cell 4 I upload the file so you can see it I appreciate your support in advance
  25. Visor

    Why does not this macro automatically number?

    Excelent!! Is what I wanted, it starts inclusive when there is no number, and of course, the conditional was necessary Thank you for your contribution has served me and is more simplified codification
Back
Top