Search results

im not sure actually I don't think i am but even if i was i don't think i would be able to tell because like i said im very very new to catia and i've only been asked to use it to code some macros in it for other people to use How can i tell if im in debug mode?

Hello everyone,im not sure if this is the appropriate place to post this but thought i should give it a try. Im currently trying to add the CATIA libraries to my vba editor when i open CatiaV5,however the "References" button in "Tools" section is greyed out and i cannot select it. I've been...

my filters are in columns B1-S1 (the headers are present there) and then from column B2 onwards its the data itself So im supposed to change the line to this? For Each rngCell In Range("B1:S1" & Range("B1" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeVisible)

Hello everyone I have made the code found below which exports all the data found in the specified range,however now i want to make it so that when filters are selected it will only export the filtered data and not everything but i do not know how to do it Here's the code i wrote : Private Sub...

Function Sequence(txtStart As String, num As Long) Dim i As Long, nStart As Long, prefix As String, c As String Set Sequence = New Collection For i = 1 To Len(txtStart) c = Mid(txtStart, i, 1) If c Like "#" Then Exit For prefix = prefix & c ' Extrai todos os...

Thanks Gasman! i managed to fix it and i went with the following code Private Sub CommandButton1_Click() Dim sourceSheet As Worksheet Set sourceSheet = ThisWorkbook.Sheets("Sheet1") Dim repeticoes As Long, seq As Collection, lastRow As Range repeticoes = Me.ComboBox1.value Set seq =...

Hello everyone I have this code right here and i want to add another something else to it but i have no clue how to Private Sub CommandButton1_Click() Dim repeticoes As Integer repeticoes = Me.ComboBox1.value Dim sourceSheet As Worksheet Dim targetSheet As Worksheet Dim...

i probably did not explain myself well so that was probably an issue on my part aswell hahaha,thanks!

Well i ended up settling for something a bit more easier to do i thought i should post the code i used incase there is someone else that is looking for the same thing as i was I added the Microsoft outlook object library to VBA and then wrote this code: Sub SendEmail() Dim OutlookApp As...

uhh i don't think so because im not able to use that trigger,its a premium feature and you need to have a license to use it.. The flow i made was a instant cloud flow mixed with a send e-mail(v2) trigger. I tested the flow and it works fine ,it sends the e-mail and everything. I was looking...

Hey everyone,first off im not sure if im allowed to post this here since it has more to do with power automate than excel itself but since i really dont know where to ask this i thought i should try it here. Im developing an interface in excel and now i thought of adding a feature to it...

ohhh my bad guys,will take note of that for the future! thank you once again!

turns out the thing that was mainly mucking up the file was the zoom %,so i changed the zoom % to the same one as i had (125%) i also managed to work around the resolution issue by adding scrollbars to the userforms so that they could just scroll up and down and see the userform menu thank you...

well i doubt they would be able to change the resolution,most of them are not tech savvy at all but it is a very valid point Do you have any idea on how i might be able to make my code handle different resolutions?

ill take a look at the resizer! well what im thinking about doing is taking my monitor there and see if it works fine (hopefully)

Hello everyone I have a question regarding the resolution and zoom of a monitor. I am currently doing an Internship in a company and they have asked me to develop an interface in VBA that will be used in the Tear Down area of the company. Currently the interface is almost finished,however i am...

Ill give it a try and see if it can help me out if i find the solution ill post it back here in case anyone is in need of a similar thing!

thank you for answering Uncle Gizmo! But im getting an error on this line "GetWeekNumber(dataArr(i, 7)) = GetWeekNumber(dataArr(i, 6)) Then" its a ByRef argument type mismatch error i've been trying to fix it but have been unable to so far..

Hello everyone I recently made the code below which reads the values inside certain columns and verifies if they are all on the same row and increments if the combination is the same as the one defined But now i want to add another feature to it and im not sure how to go about doing it which is...

yeah it was kinda like that, 2 minutes after i posted here i managed to make it work:ROFLMAO: this was the code i used if anyone else is in need of the same thing Dim data As Date data = CalendarForm.GetDate(MaximumDate:=Date, FirstDayOfWeek:=Monday) thank you for answering tho Gasman !