Is there a way to use macros on excel online? I have a spreadsheet that I want to have a search button on the summary sheet that searches all other sheets in the workbook for a specific invoice #. I have a macro that does this on excel 2010 on my computer, but as soon as I save it to the online folder in OneDrive the macro no longer works. Please Help!!!
Hello,
Excel online does not support VBA. Macros and custom functions will not run, and there is no way to make them run. VBA only runs in the desktop client, not online and not on Excel mobile.
Don't shoot the messenger.
Cheers, teylyn
I just discovered a simpler way to search the entire workbook in the desktop version, but is also not supported in the online version. CTRL+F, then change from "Sheet" to "Workbook". Excel online does not have the "Workbook" search option. Any ideas if the Excel Online version will get more advanced features?
Excel online is getting new features all the time. If and when which feature is added is anyone's guess, though.
Thank you for your help on this! Have a great day.
Hi Friends,
I’m working in stock broking company, I am into commission processing, Every month I need to configure commission structure for multiple Agents (code)
So I want to simplify the process as I am working on weekends also for the same.
Scheme: MR
Plan: w
Agent: ARN-3077
Agent Category ID: 1003
Brok Type ID: 1
From Date: 01/01/2017
To Date: 31/03/2017
From Amount: 0
To Amount: 9999999999999.99
Rate: 1.5
Remarks: Ltr.21789.Dtd.01.02.2017
City Category: B-15
frommonth: 366
tomonth: 1095
This is the format for the for configuring commission rate. After creating excel file will upload the same in one application.
Please any one help on the same and create a macro(User form to enter the data) to automate the same.. my requirements is as below
Suppose If I want to configure commission structure to 100 agents.. 1st I will upload all agent id’s and then I will enter remaining parameters shown in above table after entering all parameters I want an option in user form to choose to select Agent code. After choosing agent code I will hit enter and all fields should get clear so that I will update all fields again with different scheme code.. after finishing I want finish button to hit and all the data get export one excel file…
Please create one user form as per my requirements....Thank you
please ignore grammar mistakes.
Devendra.dvm welcome to the forum
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Devendra.dvm welcome to the forum
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
m unable find new thread button
Hello, guys. Zoho sheets have something similar to VBA editor.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks