宏观条件未被执行，即使遇到了。 [英] Macro conditions not being executed, even when met.

问题描述

嗨大家好，


我有一个拍卖师系统，并在表格上有我的字段：lot（项目），底价（[Reserve]）和最小到目前为止成功出价（[Min]）。然后有一个文本框供用户输入他们的出价（[出价]）。我为此设置了一个宏：

Hi folks,

I have a system for an auctioneer and have on the form I have the fields: lot (the item), reserve price ([Reserve]) and minimum successful bid so far ([Min]). There is then a text box for the user to input their bid ([Bid]). I have set up a macro for this:

展开 | 选择 | Wrap | 行号

推荐答案

山姆，我应警告你，虽然我们的一些成员确实对使用宏有所了解，但它很少用于专业。


我们大多数人在我们的项目中专门使用VBA。

Sam, I should warn you that, although some of our members do know a bit about using macros, it''s very rarely used professionally.

Most of us use VBA exclusively in our projects.

我确实试图通过它的逻辑，我发现很难没有发布任何数据。


也许如果你为所有控件发布了一组数据你参考并解释它是如何表现的你用这些数据进行了测试，有人可以更容易地看到问题。

I did try to go through the logic of it and I found it difficult without any data posted.

Perhaps if you posted a set of data for all the controls you refer to and explain how it behaved when you tested with that data someone could see the problem more easily.

Ok fair point。


让我们说我有很多对于一间卧室的公寓，当用户选择此项时（从组合框中，''Lot''）''Min''，''Reserve''的值会相应地改变。


所以他们选择一居室公寓，最低价格为109,400英镑，储备金为90,000英镑。


然后有一个文本框供他们输入他们的出价，名为出价。当他们按下制作出价！时按钮它应该执行宏。如果没有选择批次，他们会收到一条错误消息，上面写着请选择一个要竞标的地段;这样可行。如果Bid中有很多但没有价值，或者出价低于1000英镑，那么他们会收到一条错误消息，上面写着请输入实质性出价;这也有效。


然而，只要他们输入超过1000的数字，就什么都不执行。即使它是1001英镑或1,513,500英镑。


任何想法？

Ok fair point.

Let''s say I have a lot for a 1 bedroom apartment, when the user chooses this (from a combo box, ''Lot'') the values of ''Min'', ''Reserve'' change accordingly.

So they choose 1 bedroom apartment and the value appears in Min as ￡109,400 and Reserve as ￡90,000.

There is then a text box for them to enter their bid in, which is named ''Bid''. When they press the "Make Bid!" button it should execute the macro. If there is no Lot selected they get an error message saying "Please choose a lot to bid for"; that works. If there is a Lot but no value in Bid, or the Bid is less than ￡1000 then they get an error message saying "Please enter a substantial bid"; that also works.

However as soon as they enter a number over 1000 nothing at all executes. Even if it''s ￡1001 or ￡1,513,500.

Any ideas?

这篇关于宏观条件未被执行，即使遇到了。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！