Results for "vba combine between elements"

Hi,

a proposal. select the day in L5, check if this works for your excel version.

You speak french, don't you? you can post your message in the french speaking part of this forum.

Thank you for the solution, Merci beaucoup!

Sorry for not clearing the things, it's something like this , so what i'm looking for is a fucntion that allows me to see the content of each day only by clicking on the day ( like when i click on Monday, it shows automaticly the subject and its content..)

Hi,

Your request is quite short. Can you explain a little bit more and provide us with a sample excel file with some basic datas and the expected results ?

I have to create a Time table including the Subjects + their content, and i need to combine between all these elements.. anyone can help?

Hi ! Lisa Nguyen,

Here, your Excel File is back, with automatic conversion.

If you agree, you can display the corresponding color with your VBA Module3. Sub RGB_TO_HEX_COLOR()

See my Note in Sheet1.

hi,

code fixed for the update.

Hi,

If you're new to VBA, you can find a course here:

https://www.excel-pratique.com/en/vba

Hi,

You need to enter your VBA code here (for example, the sample code):

Then, list the names to be replaced below:

And you will then get the obfuscated code:

Breaking News,

Excel File Version2 is coming Now.

Best Regards.

I understand you. Thank you

Dear,

To solve your problems, I would completely redesign and rework your application, but that's not the kind of application I want to spend time on.

Thank you for the responds.When i select the sheet name and the year then click the filter buttonit gives me error code 1004 and hihlight as attached

The second issues is after saving data, when you search by year and month then edit the data and you forget to click the update button and clik the save button again it will save as new, but if it can prevent duplicate by year and month. I hope my explaination is clear.

Thank you

hello,

I want to filter by sheet name and year to the monthly summary.

select the sheet via the drop-downlist linked to the field insurance name.

And also want to prevent duplicate year and month when saving data on the user form.

Can you explain this with more details ? Give the steps (with data) to reproduce the issue, show the issue and document the expected result for the given data.

Please kindly assist me with error am getting and I have attached a copy.

I want to filter by sheet name and year to the monthly summary.

And also want to prevent duplicate year and month when saving data on the user form.

Thank you

Thank you so much.

That has solved my problems.

That when you activate the active sheet and populate the fileds and save it. Then you should be able to edit the submitted data by activating the active sheet and search using year and month criteria to populate the other fields. Edit and hit the update button.

Thank you

hi,

It is not working as expected

How do you expect it to work?

It is not working as expected so I want to change it to the combobox. Am asking to clarify if its only the search textbox to be changed to combobox or any other one. Thank you

Hello,

First of all, is this working as expected?

Take my suggestion for what it is "I would do it differently", but if you are happy with how it works, there is no need to change.