Enable DTPicker Calendar in Excel/VBA
Hello! How are you? I am unable to enable the DTPicker calendar in Excel/VBA. I have already contacted Microsoft, and they told me that this control is already native to the version, but this control is not appearing for me. I have even downloaded MSCOMCT2.OCX, but it still does not appear. Please, someone help me to enable this control in my Excel/VBA.
Looking to hide content unless a check box is clicked in the file.
This is going to sound probably a bit odd, but I'm trying to organize some stuff for a video game. I have several mods installed, and I want to make the excel file friendly for people who don't use mods and use mods (as I also swing between the two). Essentially, I want to mark certain content to appear and disappear when a check box is engaged and disengaged. Hopefully I explained that alright. Is there a way to do something like that in excel?
Automating Party Transactions in Excel Using VLOOKUP and VBA Macros or anything
Hi everyone, I have a main sheet named "DAILY INWARD OUTWARD" that contains transactions for over 50 parties. Each party does multiple transactions, and I need to manage their stocks. Currently, I manually create separate sheets for each party and record their transactions, which is time-consuming. See this is my master sheet and I make stocks like this That month Jodhka made 4 transactions, so by searching in master sheet all over made manually my diff party list. likewise i have to maintain 100+ party details, so anyone can help me reagarding this? I would like to automate this process using VLOOKUP and VBA macros or anything. Specifically, I need help with: Using VLOOKUP to fetch transactions from the main sheet to individual party sheets. Writing a VBA macro to create separate sheets for each party and copy their transactions from the main sheet. Any guidance or examples on how to achieve this would be greatly appreciated. Thank you!
KB5002653 issue with the Kernel Function GetCommandLineW
Hello, Just to warn about this specific issue, since the installation of the KB5002653 , From an Excel 2016 VBA the function GetCommandLineW give a truncated/different result. Sample Code: Declare Function GetCommandLine Lib "kernel32" Alias "GetCommandLineW" () As Long Declare Function lstrlenW Lib "kernel32" (ByVal lpString As Long) As Long Declare Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (MyDest As Any, MySource As Any, ByVal MySize As Long) Function ReadCmdLine() As String Dim pCmdLine As Long ' Pointer to the string Dim Buffer() As Byte Dim StrLen As Long ' Get the pointer to the command line string pCmdLine = GetCommandLine StrLen = lstrlenW(pCmdLine) * 2 If StrLen Then ReDim Buffer(0 To (StrLen - 1)) As Byte CopyMemory Buffer(0), ByVal pCmdLine, StrLen ReadCmdLine = Buffer End If End Function Before the KB I had : "C:\PROGRA~2\MICROS~2\Office16\EXCEL.EXE excelfile.xlsm /parameter" After the KB I have : ""C:\PROGRA~2\MICROS~2\Office16\EXCEL.EXE" excelfile.xlsm"
Solver VBA doesn't apply all constraints
I have the following VBA code: SolverReset SolverOk SetCell:="$C$27", MaxMinVal:=1, ValueOf:=0, ByChange:="$C$22:$C$24", _ Engine:=1, EngineDesc:="GRG Nonlinear" SolverAdd CellRef:="$C$24", Relation:=1, FormulaText:="($C$22+$C$23)*2" SolverAdd CellRef:="$C$30", Relation:=1, FormulaText:="3" SolverAdd CellRef:="$C$30", Relation:=3, FormulaText:="1" SolverAdd CellRef:="$C$22", Relation:=1, FormulaText:="12" SolverAdd CellRef:="$C$23", Relation:=1, FormulaText:="3" SolverAdd CellRef:="$C$24", Relation:=3, FormulaText:="0" SolverAdd CellRef:="$C$22", Relation:=4, FormulaText:="integer" SolverAdd CellRef:="$C$23", Relation:=4, FormulaText:="integer" SolverAdd CellRef:="$C$24", Relation:=4, FormulaText:="integer" SolverOk SetCell:="$C$27", MaxMinVal:=1, ValueOf:=0, ByChange:="$C$22:$C$24", _ Engine:=1, EngineDesc:="GRG Nonlinear" SolverSolve userFinish:=True when I run it the solver doesn't apply the constraint C30 >= 1, and when I open up the solver dialog to see the constraints used it is missing from the solver. If the constraint is then added in the dialog it does get solved properly.REMOVE A CHECKBOX FROM EXCEL WORKSHEET
I was handed an Excel worksheet that has three checkboxes that I wish to remove but cannot seem to remove them. Excel Help says to right click the Box and then hit Delete. There is no Delete in the ensuing dropdown menu and Delete on the keyboard does not work. Any suggestions?Help me with Formulas pls!
Hi everyone, I have a main sheet named "DAILY INWARD OUTWARD" that contains transactions for over 50 parties. Each party does multiple transactions, and I need to manage their stocks. Currently, I manually create separate sheets for each party and record their transactions, which is time-consuming. See this is my master sheet and I make stocks like this That month Jodhka made 4 transactions, so by searching in master sheet all over made manually my diff party list. likewise i have to maintain 100+ party details, so anyone can help me reagarding this? I would like to automate this process using VLOOKUP and VBA macros or anything. Specifically, I need help with: Using VLOOKUP to fetch transactions from the main sheet to individual party sheets. Writing a VBA macro to create separate sheets for each party and copy their transactions from the main sheet. Any guidance or examples on how to achieve this would be greatly appreciated. Thank you! hereby attaching excel file too https://filetransfer.io/data-package/beXdVs3F#linkPlease update Excel to handle more than 15 digit numbers!
I'm a professional database designer, and this limitation has caused me no end of headaches. The problem: numbers that are more than 15 digits long have all digits after the 15th converted into zeros. Microsoft provided workaround: format the the field as text. This workaround is only useful if you are doing data entry directly into an existing Excel spreadsheet that you are able to format the cells ahead of time. It's incredibly unhelpful when you are pushing and pulling data from different data sources. For example, if I need to push data out of a program like FileMaker to Excel, and the system I am pushing from has numeric fields (in particular ID fields), excel sees them as numbers and replaces the digits after the 15th. This jacks up formulas as well as any data synching possibilities. In situations like that, I end up having to export the data as .csv file, and then pull it in to an excel sheet and then do a bunch of conversion options on import (which does not always work, btw). But this is not a practical solution for every day users who are not tech savvy. I should be able to export the data directly to excel without the data being converted. This has been a big problem for every client I have that requires data being pushed to Excel. And this problem has existed for decades. Other spreadsheet programs (like google sheets) do not appear to have this issue. Can someone please explain why Excel continues to cling to this archaic standard? Are there any plans to update Excel to handle more than 15 digits? I know I am not the only one who has run into this problem. I've seen all kinds of posts about it. But trying to let Microsoft know how much of a problem this is has been a challenge. Their article on the subject had a link to give product feedback, and that link led me to this space. So here it is: product feedback for Excel. PLEASE FIX THIS! Thank you. Chris
Excel VBA
good morning guys , my name is Logan. I am new to this community and also new to the whole excel VBA thing. I need your help in a project I am working on which is basically spreadsheet with 2 tabs (Database and Reports). what I want is automation of the process report capturing from the Database sheet within the specified Dates when "generate report button" is pressed. like for example: if the diagnosis is malaria , designation is GPOC ,age group is above 5 years and type of visit is a new visit then update the circled cell by adding 1. this goes for the rest on the listed diagnosis. and thanks in advance.
